Free A00-202 Web TestEngine Demo

Q17 Single choice

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;D.proc sql;
create table two as select job, level, salary * 0.1 as bonus from one
where calculated bonus > 20;
quit;

A00-202 Web TestEngine demo