Archive for August, 2009
SAS Certified Adv Programmer 50 Questions (28)
Which one of the following statements displays all user-defined macro variables in the SAS log? a. %put user=; b. %put user; c. %put _user_; d. options mprint
SAS Certified Adv Programmer 50 Questions (27)
Given the following partial SAS log: 11 %macro a(location); 12 %if &location = FL %then 13 libname &location ‘c:\state’; 14 %mend; 15 %a(FL) NOTE: SCL source line. 16 libname mylib ‘c:\mydata’; ——- 22 ERROR: Libname FL is not assigned. ERROR: Error in the LIBNAME statement. ERROR 22-7: Invalid option name LIBNAME. Which of the following […]
SAS Certified Adv Programmer 50 Questions (26)
The following SAS program is submitted: %let mvar=bye; data _null_; var1=’hi’; var2=’hello’; call symput(‘var1’ || “&mvar”, var2); run; Which one of the following is the name of the macro variable created by the CALL SYMPUT statement? a. var1 b. hibye c. var1bye d. No macro variable is created because the CALL SYMPUT statement is not […]
SAS Certified Adv Programmer 50 Questions (25)
Which one of the following is the purpose of the %STR function? a. to extract part of a macro character value b. to treat semicolons and other selected tokens as text c. to concatenate the values of two macro variables into one d. to extract part of a macro variable based on matching criteria
SAS Certified Adv Programmer 50 Questions (24)
The following SAS program is submitted: %let type=RANCH; proc sql; create view houses as select * from sasuser.houses where style=”&type”; quit; %let type=CONDO; proc print data=houses; run; The report that is produced displays observations whose value of Style are all equal to RANCH. Which one of the following functions on the WHERE clause resolves the […]