SAS Training

SAS Certified Adv Programmer 50 Questions (16)

Given the following SAS data set Mylib.Mydata:

Mylib.Mydata

The following SAS program is submitted:

data _null_;
    set mylib.mydata;
    call symput('animal' || left(_n_), name);
run;
%let i=2;
title "The value is &&animal&i";

Which one of the following does the TITLE statement resolve to?

a. The value is Dog
b. The value is animal2
c. The value is Brown
d. The value is &animal2

SAS Certified Adv Programmer 50 Questions (15)

A batch (non -interactive) job is submitted on Wednesday, 20 January 1999 (SAS date 14264). The program completes the following day.

The following code is the last step in the SAS program:

data _null_;
    call symput('mdate', input("&sysdate", date7.));
run;

Which of the following is the value of the macro variable mdate?

a. 14264
b. 14265
c. 20JAN99
d. 21JAN99

SAS Certified Adv Programmer 50 Questions (14)

Which one of the following SAS programs removes the index Jobcode from the table Staff?

a.

proc sql;
    drop index jobcode from work.staff;
quit;

b.

proc sql;
    delete index jobcode from work.staff;
quit;

c.

proc sql;
    drop index from work.staff;
quit;

d.

proc sql;
    delete index from work.staff;
quit;

SAS Certified Adv Programmer 50 Questions (13)

The following SAS program is submitted:

proc sql noprint;
    select name
        into : name1 -: name19
        from one;
quit;

Given that table One has 19 observations and 5 variables, how many macro variables are created by the above program?

a. 5
b. 6
c. 19
d. 20

SAS Certified Adv Programmer 50 Questions (12)

Which one of the following statements is true about an SQL procedure view?

a. It stores large amounts of data.
b. It updates data from multiple database tables.
c. It contains both the data and the descriptor portions.
d. It accesses the most current data in changing tables.