SAS Training

SAS Certified Adv Programmer 50 Questions (11)

The following SAS program is submitted:

%let lib=SASUSER;
%let dsn=CLASS;
proc sql;
    select name
        from dictionary.columns
            where libname="&lib" and
                  <insert code here>
quit;

Which one of the following conditions completes the WHERE clause to create a subset from the data set Dictionary.Columns about Sasuser.Class?

a.

table="&dsn"

b.

name="&dsn"

c.

member="&dsn"

d.

memname="&dsn"

SAS Certified Adv Programmer 50 Questions (10)

The following SAS program is submitted:

proc sql noprint;
    select name
        into : info separated by ' '
        from dictionary.columns
        where libname="SASHELP" and
              memname="CLASS";
quit;

Given that a SAS data set Sashelp.Class exists, which one of the following is generated by the above program?

a. a list of names
b. a syntax error in the log
c. a macro variable called info
d. a report showing metadata information

SAS Certified Adv Programmer 50 Questions (9)

Table One has five million observations. Table Two has one thousand observations. These tables have identical column attributes. Concatenating tables One and Two should result in 5,001,000 observations.

Which one of the following SAS techniques uses the least CPU time and I/O operations to process?

a. the APPEND procedure
b. the SET statement in the DATA step
c. the INSERT INTO statement in the SQL procedure
d. the OUTER UNION CORR operator in the SQL procedure

SAS Certified Adv Programmer 50 Questions (8)

Given the following SAS data sets One and Two:

One

Two

The following SAS program is submitted creating the output table Three:

data three;
    merge one (in=in1) two (in=in2);
    by num;
    if in2;
run;

Three

Which of the following SQL programs creates an equivalent SAS data set Three?

a.

proc sql;
    create table three as
        select two.num, char1, char2
            from one left join two
            on one.num=two.num;
quit;

b.

proc sql;
    create table three as
        select two.num, char1, char2
            from one right join two
            on one.num=two.num;
quit;

c.

proc sql;
    create table three as
        select two.num, char1, char2
            from one full join two
            on one.num=two.num;
quit;

d.

proc sql;
    create table three as
        select two.num, char1, char2
            from one, two
            where one.num=two.num;
quit;

SAS Certified Adv Programmer 50 Questions (7)

How many columns can an SQL procedure subquery within a WHERE or HAVING clause return to the outer query?

a. 0
b. 1
c. 2
d. the same number of columns that are in the table