SAS Certified Base Programmer 50 Questions (13)
The following SAS program is submitted: data names; title=’EDU’; if title=’EDU’ then Division=’Education’; else if title=’HR’ then Division=’Human Resources’; else Division=’Unknown’; run; Which one of the following represents the value of the variable Division in the output data set? a. Educatio b. Education c. Human Re d. Human Resources
SAS Certified Base Programmer 50 Questions (12)
The following SAS program is submitted: proc sort data=work.test; by fname descending salary; run; Which one of the following represents how the observations are sorted? a. The data set Work.Test is sorted in ascending order by both Fname and Salary values. b. The data set Work.Test is sorted in descending order by both Fname and […]
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 […]
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 […]
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