Archive for August, 2009
SAS Certified Base Programmer 123 Questions (3)
The following SAS program is submitted: data work.new; length word $7; amount = 7; if amount = 5 then word = ‘CAT’; else if amount = 7 then word = ‘DOG’; else work = ‘NONE!!!’; amount = 5; run; Which one of the following represents the values of the AMOUNT and WORD variables? A. amount […]
SAS Certified Base Programmer 123 Questions (2)
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations: libnamesastemp ‘SAS-data-library’; options obs = 500; proc print data = sasdata.prdsales (firstobs = 100); run; options obs = max; proc means data = sasdata.prdsales (firstobs = 500); run; How many observations are processed by each procedure? A. 400 for PROC PRINT […]
SAS Certified Base Programmer 123 Questions (1)
In the following SAS program, the input data files are sorted by the NAMES variable: libnametemp ‘SAS-data-library’; data temp.sales; merge temp.sales work.receipt; by names; run; Which one of the following results occurs when this program is submitted? A. The program executes successfully and a temporary SAS data set is created. B. The program executes successfully […]
SAS Certified Adv Programmer 50 Questions (50)
Which one of the following is used to create an index for a SAS data set? a. INDEX function b. INDEX= data set option c. CREATE INDEX statement in the INDEX procedure d. CREATE INDEX statement in the DATASETS procedure
SAS Certified Adv Programmer 50 Questions (49)
Which one of the following SAS programs is the most efficient in producing and removing an index from a SAS data set? a. proc datasets lib=sasuser; modify houses; index create style; index delete location; quit; b. proc datasets lib=sasuser; modify houses; index delete location; index create style; quit; c. proc datasets lib=sasuser; modify houses; delete […]