Archive for September, 2009
SAS Certified Base Programmer 123 Questions (23)
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set? A. libname sasdata ‘SAS-data-library’; data sasdata.mydata; copy mydata; run; B. libname sasdata ‘SAS-data-library’; data sasdata.mydata; keep mydata; run; C. libname sasdata ‘SAS-data-library’; data sasdata.mydata; save mydata; run; D. libname sasdata ‘SAS-data-library’; data sasdata.mydata; set mydata; […]
SAS Certified Base Programmer 123 Questions (22)
The following SAS DATA step is submitted: libnametemp ‘SAS-data-library’; data temp.report; set sasuser.houses; newvar= price * 1.04; run; Which one of the following statements is true regarding the program above? A. The program is reading from a temporary data set and writing to a temporary data set. B. The program is reading from a temporary […]
SAS Certified Base Programmer 123 Questions (21)
The following SAS SORT procedure step generates an output data set: proc sort data = sasuser.houses out = report; by style; run; In which library is the output data set stored? A. WORK B. REPORT C. HOUSES D. SASUSER
SAS Certified Base Programmer 123 Questions (20)
The following SAS program is submitted: proc sort data=work.employee; by descending fname; proc sort sort data=work.salary; by descending fname; data work.empdata; merge work.employee work.salary; by fname; run; Which one of the following statements explains why the program failed execution? A. The SORT procedures contain invalid syntax. B. The merged data sets are not permanent SAS […]
SAS Certified Base Programmer 123 Questions (19)
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE fname age Bruce 30 Dan 40 WORK.SALARY name salary Bruce 25000 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata; <insert MERGE statement here> by fname; totsal+ salary; run; Which one of the following statements completes the merge of the two […]