Archive for July, 2009

By admin | July 28, 2009

SAS Certified Base Programmer 50 Questions (11)

The following program is submitted: proc contents data=sasuser.houses; run; The exhibit below contains partial output produced by the CONTENTS procedure. Data Set Name SASUSER.HOUSES Observations 15 Member Type DATA Variables 6 Engine V9 Indexes 0 Created Tuesday, April 22, 2003 03:09:25 PM Observation Length 56 Last Modified Tuesday, April 22, 2003 03:09:25 PM Deleted Observations […]

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′;