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 […]
SAS Certified Adv Programmer 50 Questions (43)
The SAS data set Temp contains 1,000 observations and 10 variables. Which one of the following SAS DATA steps writes the variables a, b, and c to both SAS data sets One and Two? a. data one two(keep=a b c); set temp(keep=a b c d); run; b. data one two; set temp(keep=a b c); run; […]
SAS Certified Adv Programmer 50 Questions (42)
The SAS data set One consists of five million observations and has 25 variables. Which one of the following SAS programs requires the least CPU time to be processed? a. data two; set one; if year(date)=1999 and state in (‘NY’ ‘NJ’ ‘CT’) then sales=sales98*1.1; else if year(date)=2000 and state in (‘NY’ ‘NJ’ ‘CT’) then sales=sales98*1.15; […]