Archive for August, 2009
SAS Certified Adv Programmer 50 Questions (48)
The following SAS program is submitted: data new(sortedby=date); infile rawdata; input date mmddyy10. employeeID $ salary; run; Which one of the following is the purpose of the SORTEDBY= data set option? a. to specify how the data set is currently sorted b. to sort the data values in Date order in the SAS data set […]
SAS Certified Adv Programmer 50 Questions (47)
The SAS data set Sasdata.Sales has a simple index for the variable Date and a variable named Revenue with no index. In which one of the following SAS programs is the Date index considered for use? a. proc print data=sasdata.sales; by date; run; b. proc print data=sasdata.sales; where month(date)=3; run; c. data march; set sasdata.sales; […]
SAS Certified Adv Programmer 50 Questions (46)
Which one of the following SAS SORT procedure options eliminates observations with identical BY values? a. NODUP b. UNIQUE c. DISCRETE d. NODUPKEY
SAS Certified Adv Programmer 50 Questions (45)
The following SAS program is submitted: data one; do pt=1 to 14 by 2; set temp point=pt nobs=totobs; output; end; stop; run; The SAS data set Temp has 2,500,000 observations. Which one of the following represents the observations included in the data set One? a. the first 14 observations from Temp b. all 2,500,000 observations […]
SAS Certified Adv Programmer 50 Questions (44)
Which one of the following statements is true? a. A WHERE statement can select observations only from SAS data sets. b. Efficiency is affected by the placement of the WHERE statement in the DATA step. c. The FIRSTOBS= and OBS= data set options are never allowed in a step with a WHERE expression. d. There […]