SAS Certified Base Programmer 123 Questions (68)
The following SAS program is submitted: data work.total; set work.salary(keep = department wagerate); by department; if first.department then payroll = 0; payroll + wagerate; if last.department; run; The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. Which one of the following represents how many observations the WORK.TOTAL […]
SAS Certified Base Programmer 123 Questions (67)
The following SAS program is submitted: data work.total; set work.salary(keep = department wagerate); by department; if first.department then payroll = 0; payroll + wagerate; if last.department; run; The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT. Which one of the following is true regarding the program above? A. […]
SAS Certified Base Programmer 123 Questions (66)
The following SAS program is submitted: libnamesasdata ‘SAS-data-library’; data test; set sasdata.chemists (keep = job_code); if job_code = ‘chem3’ then description = ‘Senior Chemist’; run; The variable JOB_CODE is a character variable with a length of 6 bytes. Which one of the following is the length of the variable DESCRIPTION in the output data set? […]
SAS Certified Base Programmer 123 Questions (65)
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.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set. Which one of the […]
SAS Certified Base Programmer 123 Questions (64)
The following SAS DATA step is submitted: data work.accountting; set work.department; length jobcode$ 12; run; The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5. Which one of the following is the length of the variable JOBCODE in the output data set? A. 5 B. 8 C. 12 D. […]