A00-201 Exam Questions

Which one of the following SAS statements renames two variables?

The following SAS program is submitted: data work.totalsales (keep = monthsales(12)); set work.monthlysales (keep = year product sales); array monthsales(12); do i=1 to 12; monthsa...

The following SAS program is submitted: libname temp 'SAS-data-library'; data work.new; set temp.jobs; format newdate mmddyy10.; qdate = qtr(newdate); ddate = weekday(newdate); run...

59: The following SAS program is submitted: options pageno = 1; proc print data = sasuser.houses; run; proc means data = sasuser.shoes; run; The report created by the PRINT procedu...

61: The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE Fname age Bruce 40 Dan 40 WORK.SALARY Fname salary Bruce 25000 Bruce 35000 Dan 25000 The followi...

65: The following SAS program is submitted: libname sasdata 'SAS-data-library'; data test; set sasdata.chemists (keep = job_code); if job_code = 'chem3' then description = 'Senior...

66: The following SAS program is submitted: data work.test; array diff_sales[3] difsales1 - difsales3; array monthly[3] jansales febsales marsales; run; Which one of the following...

67: The following SAS program is submitted: data work.accounting; set work.dept1 work.dept2; run; A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DE...

68: The SASDATA.BANKS data set has five observations when the following SAS program is submitted: libname sasdata 'SAS-data-library'; data allobs; set sasdata.banks; capital=0; do...

69: The following SAS program is submitted: data work.test; Author = 'Agatha Christie'; First = substr(scan(author,1,','),1,1); run; Which one of the following is the length of the...

70: The following SAS program is submitted: libname company 'SAS-data-library'; proc sort data = company.payroll; by EmployeeIDNumber; run; Write access has been granted to the COM...

The following SAS program is submitted: data work.final; set sasuser.houses; format price dollar.; keep price style; run; Which one of the following statements about the WORK.FINAL...

The following SAS program is submitted: data work.new; set sasuser.houses; length comment $ 50; comment = 'This is a sample comment for the houses data set.'; run; Which one of the...

Which one of the following programs can be used to display the first 10 observations of the SASUSER.HOUSES data set in the default order?

Which one of the following programs correctly displays a histogram for the variable POPULATION?