Archive for September, 2009
SAS Certified Base Programmer 123 Questions (53)
The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 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 sequentially by descending expense values within each […]
SAS Certified Base Programmer 123 Questions (52)
The SAS data set QTR1_REVENUE is listed below: destination revenue YYZ 53634 FRA 62129 FRA 75962 RDU 76254 YYZ 82174 The following SAS program is submitted: proc sort data = qtr1_revenue; by destination descending revenue; run; Which one of the following represents the first observation in the output data set? A. destination revenue YYZ 82174 […]
SAS Certified Base Programmer 123 Questions (51)
The following SAS program is submitted: libnamecompany ‘SAS-data-library’; proc sort data = company.payroll; by EmployeeIDNumber; run; Write access has been granted to the COMPANY library. Which one of the following represents how the observations are sorted? A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber. B. COMPANY.PAYROLL is stored in original order, and a new […]
SAS Certified Base Programmer 123 Questions (50)
The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 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 sequentially by ascending expense values within each […]
SAS Certified Base Programmer 123 Questions (49)
The SAS data set WORK.AWARDS is listed below: fname points Amy 2 Amy 1 Gerard 3 Wang 3 Wang 1 Wang 2 The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run; Which one of the following represents how the observations are sorted? A. Wang 3 Gerard 3 Wang […]