By admin | July 28, 2009

SAS Certified Base Programmer 50 Questions (10)

The SAS data set Sashelp.Prdsale contains the variables Region and Salary with 4 observations per Region. Sashelp.Prdsale is sorted primarily by Region and with Region by Salary in descending order. The following program is submitted: data one; set sashelp.prdsale; retain temp; by region descending salary; if first.region then do; temp=salary; output; end; if last.region then […]

By admin | July 28, 2009

SAS Certified Base Programmer 50 Questions (9)

Which one of the following displays the contents of an external file from within a SAS session? a. the LIST procedure b. the PRINT procedure c. the FSLIST procedure d. the VIEWTABLE procedure

By admin | July 28, 2009

SAS Certified Base Programmer 50 Questions (8)

Which one of the following SAS date formats displays the SAS date value for January 16, 2002 in the form of 16/01/2002? a. DATE10. b. DDMMYY10. c. WEEKDATE10. d. DDMMYYYY10.

By admin | July 28, 2009

SAS Certified Base Programmer 50 Questions (7)

The following SAS program is submitted: data newstaff; set staff; <insert WHERE statement here> run; Which one of the following WHERE statements completes the program and selects only observations with a Hire_date of February 23,2000? a. where hire_date=’23feb2000’d; b. where hire_date=’23feb2000′; c. where hire_date=’02/23/2000’d; d. where hire_date=’02/23/2000′;

By admin | July 27, 2009

SAS Certified Base Programmer 50 Questions (6)

Which action assigns a reference named SALES to a permanent SAS data library? a. Issuing the command: libref SALES ‘SAS-data-library’ b. Issuing the command: libname SALES ‘SAS-data-library’ c. Submitting the statement: libref SALES ‘SAS-data-library’; d. Submitting the statement: libname SALES ‘SAS-data-library’;