By admin | September 4, 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; […]

By admin | September 4, 2009

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 […]

By admin | September 4, 2009

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

By admin | September 4, 2009

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 […]

By admin | September 4, 2009

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 […]