Archive for September, 2009

By admin | September 18, 2009

SAS Certified Base Programmer 123 Questions (63)

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 sal = salary)); C. set work.dept1 work.dept2(rename = jcode = jobcode sal = salary); D. set work.dept1 work.dept2(rename = (jcode jobcode) (sal salary));

By admin | September 18, 2009

SAS Certified Base Programmer 123 Questions (62)

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 JCODE is written to the output data set. B. The variable JOBCODE is written to the output data set. C. Neither variable JCODE nor JOBCODE is […]

By admin | September 18, 2009

SAS Certified Base Programmer 123 Questions (61)

The following SAS program is submitted: data work.passengers; if OrigPassengers = . then OrigPassengers=100; TransPassengers= 100; OrigPassengers= .; NonPaying= 10; TotalPassengers= sum (OrigPassengers, TransPassengers); run; Which one of the following is the value of the TOTALPASSENGERS variable in the output data set? A. 100 B. 110 C. 200 D. . (missing numeric value)

By admin | September 18, 2009

SAS Certified Base Programmer 123 Questions (60)

The following SAS program is submitted: data work.passengers; if OrigPassengers = . then OrigPassengers=100; TransPassengers= 100; OrigPassengers= .; NonPaying= 10; TotalPassengers= OrigPassengers + TransPassengers; run; Which one of the following is the value of the TOTALPASSENGERS variable in the output data set? A. 100 B. 110 C. 200 D. . (missing numeric value)

By admin | September 18, 2009

SAS Certified Base Programmer 123 Questions (59)

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 JOBCATEGORY in the output data set? A. FA B. FA1 C. FA 1 D. ‘ ‘ (missing character value)