Archive for August, 2009
SAS Certified Base Programmer 50 Questions (38)
Assume the SAS data set Sasuser.Houses has four numeric variables. The following SAS program is submitted: proc means data=sasuser.houses mean; <insert statement(s) here> run; The following report is produced: style N Obs Variable Mean CONDO 4 bedrooms 2.7500000 baths 2.1250000 RANCH 4 bedrooms 2.2500002500000 baths 2.0000000 SPLIT 3 bedrooms 2.6666667 baths 1.8333333 TWOSTORY 4 bedrooms […]
SAS Certified Base Programmer 50 Questions (37)
The following SAS program is submitted: data work.accounting; length jobcode $ 12; set work.department; run; The Work.Department SAS data set contains a character variable named jobcode with a length of 5. Which of the following is the length of the variable jobcode in the output data set? a. 5 b. 8 c. 12 d. The […]
SAS Certified Base Programmer 50 Questions (36)
The SAS data set Employee_info is listed below. employee bonus 2542 100.00 3612 133.15 2198 234.34 2198 111.12 The following SAS program is submitted: proc sort data=employee_info; <insert BY statement here> run; Which one of the following BY statements completes the program and sorts the data in sequential order by descending bonus values within ascending […]
SAS Certified Base Programmer 50 Questions (35)
The contents of the SAS data set Sasdata.Group are listed below. name age Janice 10 Henri 11 Michele 11 Susan 12 The following SAS program is submitted using the Sasdata.Group data set as input: libname sasdata ‘SAS-data-library’; data group; set sasdata.group; file ‘file-specification’; put name $15. @5 age 2.; run; Which one of the following […]
SAS Certified Base Programmer 50 Questions (34)
The SAS data sets Work.Employee and Work.Salary are shown below. Work.Employee fname age Bruce 30 Dan 40 Work.Salary fname salary Bruce 25000 Bruce 35000 Dan 25000 The following merged SAS data set is generated: Work.Empdata fname age totsal Bruce 30 60000 Dan 40 25000 Which one of the following SAS programs created the merged data […]