By admin | August 21, 2009

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

By admin | August 21, 2009

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

By admin | August 21, 2009

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

By admin | August 21, 2009

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

By admin | August 21, 2009

SAS Certified Adv Programmer 50 Questions (41)

Which one of the following represents where the input is measured when using SAS data sets as input to a DATA step? a. between the storage on disk and utility swap files b. between the storage on disk and the input buffers c. between the input buffers and the program data vector (PDV) d. between […]