By admin | August 24, 2009

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

By admin | August 24, 2009

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

By admin | August 24, 2009

SAS Certified Adv Programmer 50 Questions (48)

The following SAS program is submitted: data new(sortedby=date); infile rawdata; input date mmddyy10. employeeID $ salary; run; Which one of the following is the purpose of the SORTEDBY= data set option? a. to specify how the data set is currently sorted b. to sort the data values in Date order in the SAS data set […]

By admin | August 24, 2009

SAS Certified Adv Programmer 50 Questions (47)

The SAS data set Sasdata.Sales has a simple index for the variable Date and a variable named Revenue with no index. In which one of the following SAS programs is the Date index considered for use? a. proc print data=sasdata.sales; by date; run; b. proc print data=sasdata.sales; where month(date)=3; run; c. data march; set sasdata.sales; […]

By admin | August 24, 2009

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