SAS Training

SAS Certified Adv Programmer 130 Questions (38)

The following SAS program is submitted:

%macro execute;
<insert statement here> 
    proc print data = sasuser.houses;
    run;
%end;
%mend;

Which of the following completes the above program so that it executes on Tuesday?

A. %if &sysday = Tuesday %then %do;
B. %if &sysday = ‘Tuesday’ %then %do;
C. %if “&sysday” = Tuesday %then %do;
D. %if ‘&sysday’ = ‘Tuesday’ %then %do;

SAS Certified Adv Programmer 130 Questions (37)

Given the following SAS data sets ONE and TWO:

ONE 
NUM CHAR1 
1   A1 
1   A2 
2   B1 
2   B2 
5   V

TWO 
NUM CHAR2
2   X1
2   X2 
3   Y
4   D

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

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

THREE 
NUM CHAR1 CHAR2
2   B1    X1
2   B1    X2
2   B2    X1
2   B2    X2

Which one of the following DATA step programs creates an equivalent SAS data set THREE?

A.

data three;
    merge one two;
    by num;
run;

B.

data three;
    set one;
    set two;
    by num;
run;

merge one two;
    by num;
run;

C.

data three;
    set one;
    set two;
    by num;
run;
    by num;
run;

D.

data three;
    set one;
    do i = 1 to numobs;
        set two(rename = (num = num2)) point = i nobs = numobs;
        if num2 = num then output;
    end;
    drop num2;
run; 

SAS Certified Adv Programmer 130 Questions (36)

Which one of the following SAS programs uses the most amount of memory resources for output buffers?

A.

data new(bufsize = 1000 bufno = 5);
    set temp;
run;

B.

data new(bufsize = 1000 bufno = 2);
    set temp;
run;

C.

data new(bufsize = 2000 bufno = 3);
    set temp;
run;

D.

data new(bufsize 4000 bufno = 1);
    set temp;
run; 

SAS Certified Adv Programmer 130 Questions (35)

The following SAS FORMAT procedure is submitted:

proc format lib = sasuser;
    value tempc 
        low < 0 = 'BELOW FREEZING'
        0<5 = 'COLD'
        5< 10= 'MILD'
        10< 15 = 'WARM' 
        15 < high = 'HOT';
run;

How is the value 10 displayed when the format TEMPC is applied?

A.10
B. MILD
C. WARM
D. BELOW FREEZING

SAS Certified Adv Programmer 130 Questions (34)

The following SAS program is submitted:

data temp;
    array points { 3,2 } _temporary_ (10,20,30,40,50,60);
    score = points { 2,1 };
run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

A. 10
B. 20
C. 30
D. 40