Archive for December, 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 […]
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 […]
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
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
SAS Certified Adv Programmer 130 Questions (33)
Which one of the following SAS SORT procedure options eliminates identical consecutive observations? A. NODUP B. UNIQUE C. DISTINCT D. NODUPKEY