2010-01-27 17:18
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;ru… Read More
Blog Directory > Internet Blogs > SAS Certification Questions internet Blog >
Sas Certification Questions Blog
sas-certification-questions.blogspot.com
Tags:
variable
jobcode
length
program
totalpassengers
origpassengers
variable payroll represent
workdeptrename jcode
variable jobcode
payroll
Collection of Practice questions and Answers for SAS Certification...
2010-01-27 17:17
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 Chemist';run;The v… Read More
2010-01-27 17:17
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… Read More
2010-01-27 17:16
The following SAS DATA step is submitted:data work.accounting;set work.department;length jobcode $ 12;run;The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a… Read More
2010-01-27 17:15
Which one of the following SAS statements renames two variables?A. set work.dept1 work.dept2(rename = (jcode = jobcode) (sal = salary));B. set work.dept1 work.dept2(rename = (jcode = jobcode… Read More
2010-01-27 17:15
The following SAS program is submitted:data work.company;set work.dept1(keep = jobcode) work.dept2(rename = (jcode = jobcode));run;Which one of the following is the result?A. The variable JC… Read More
2010-01-27 17:15
The following SAS program is submitted:data work.passengers;if OrigPassengers = . then OrigPassengers = 100;TransPassengers = 100;OrigPassengers = .;NonPaying = 10;TotalPassengers = sum (Ori… Read More
2010-01-27 17:13
The following SAS program is submitted:data work.passengers;if OrigPassengers = . then OrigPassengers = 100;TransPassengers = 100;OrigPassengers = .;NonPaying = 10;TotalPassengers = OrigPass… Read More
2010-01-27 17:13
The following SAS program is submitted:data work.staff;JobCategory = 'FA';JobLevel = '1';JobCategory = JobCategory || JobLevel;run;Which one of the following is the value of the variable JOB… Read More
2010-01-27 17:12
The following SAS program is submitted:data work.one;x = 3;y = 2;z = x ** y;run;Which one of the following is the value of the variable Z in the output data set?A. 6B. 9C. . (missing numeric… Read More
2010-01-27 17:12
The SAS data set named WORK.TEST is listed below:capacity airplanetype staff150 Large 10Which one of the following SAS programs created this data set?A. data work.test;capacity = 150;if 100… Read More
2010-01-27 17:11
The following SAS program is submitted:data work.flights;destination = 'cph';select(destination);when('LHR') city = 'London';when('CPH') city = 'Copenhagen';otherwise city = 'Other';end;run;… Read More
2010-01-27 17:10
The following SAS program is submitted:data work.flights;destination = 'CPH';select(destination);when('LHR') city = 'London';when('CPH') city = 'Copenhagen';otherwise;end;run;Which one of th… Read More
2010-01-27 17:10
The SAS data set EMPLOYEE_INFO is listed below:IDNumber Expenses2542 100.003612 133.152198 234.342198 111.12The following SAS program is submitted:proc sort data = employee_info;run;Which o… Read More
2010-01-27 17:09
The SAS data set QTR1_REVENUE is listed below:destination revenueYYZ 53634FRA 62129FRA 75962RDU 76254YYZ 82174The following SAS program is submitted:proc sort data = qtr1_revenue;by destinat… Read More
2010-01-27 17:08
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 COMPANY library.Which… Read More
2010-01-27 17:08
The SAS data set EMPLOYEE_INFO is listed below:IDNumber Expenses2542 100.003612 133.152198 234.342198 111.12The following SAS program is submitted:proc sort data = employee_info;run;Which on… Read More
2010-01-27 17:07
The SAS data set WORK.AWARDS is listed below:fname pointsAmy 2Amy 1Gerard 3Wang 3Wang 1Wang 2The following SAS program is submitted:proc sort data = work.awards;by descending fname points;ru… Read More
2010-01-27 17:07
The following SAS program is submitted:data work.test;set work.staff (keep = jansales febsales marsales);array diff_sales{3} difsales1 - difsales3;array monthly{3} jansales febsales marsales… Read More
2010-01-27 17:06
The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.The following SAS program is submitted:proc sort data = work.test out = work.testsorted;by nam… Read More
2010-01-27 17:05
Which one of the following statements is true regarding the name of a SAS array?A. It is saved with the data set.B. It can be used in procedures.C. It exists only for the duration of the DAT… Read More
2010-01-27 17:05
The following SAS program is submitted:data stats;set revenue;array weekly{5} mon tue wed thu fri;total = weekly{i} * .25;output;end;run;Which one of the following DO statements completes th… Read More
2010-01-27 17:04
The following SAS program is submitted:data work.test;array agents{4} $ 12 sales1 - sales4;run;Which one of the following represents the variables that are contained in the output data set?A… Read More
2010-01-27 17:03
On which portion(s) of a SAS data set does the PRINT procedure report?A. the data portion onlyB. the descriptor portion onlyC. the descriptor portion and the data portionD. neither the data… Read More
2010-01-27 17:02
Which one of the following SAS procedures displays the data portion of a SAS data set?A. PRINTB. FSLISTC. CONTENTSD. DATASETS Read More
Subscribe to Sas Certification Questions
Get updates delivered right to your inbox!