A00-202 Advanced programming Certification Exam

Demo Question 11.

Given the following SAS data set ONE. ONE JOB LEVEL SALARY ------------------------------------------ ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created: TWO JOB LEVEL BONUS ------------------------------------- ACC 2 30 MGR 3 70 MGR 2 40 Which one of the following SAS programs creates data set TWO?

A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;
B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;
C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;
D. proc sql;proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;


Display Answer

Answer: D

Explanation: