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. […]

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 […]

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 […]

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

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