By admin | January 3, 2010

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;

By admin | December 23, 2009

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; 

By admin | December 23, 2009

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; 

By admin | December 23, 2009

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

By admin | December 23, 2009

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

Pages: Prev 1 2 3 4 5 6 ... 55 56 Next