By admin | January 7, 2010

SAS Certified Adv Programmer 130 Questions (43)

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable? A. CHECK B. UNIQUE C. FORMAT D. DISTINCT

By admin | January 7, 2010

SAS Certified Adv Programmer 130 Questions (42)

The following SAS program is submitted: %macro test(var); %let jobs = BLACKSMITH WORDSMITH SWORDSMITH; %let type = %index(&jobs,&var); %mend; %test(SMITH) Which one of the following is the resulting value of the macro variable TYPE? A. 0 B. 3 C. 6 D. null

By admin | January 3, 2010

SAS Certified Adv Programmer 130 Questions (41)

Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START? A. %let start = today(),weekdate.; B. %let start = today(),format=weekdate.; C. %let start = %sysfunc(today(),weekdate.); D. %let start = %sysfunc(%today(),weekdate.);

By admin | January 3, 2010

SAS Certified Adv Programmer 130 Questions (40)

Given the following SAS data sets ONE and TWO: ONE OBS COMMON X 1 A 10 2 A 13 3 A 14 4 B 9 5 C 8 6 C 14 TWO OBS COMMON Y 1 A 1 2 A 3 3 B 4 4 B 2 5 C 5 The following SAS DATA step […]

By admin | January 3, 2010

SAS Certified Adv Programmer 130 Questions (39)

Which one of the following statements is true regarding a SAS DATA step view? A. It allows write capabilities. B. It contains global statements. C. It contains data and a descriptor portion. D. It contains a partially compiled DATA step.