Given the SAS data set ONE:

ONE REP COST -------- ------- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted:

proc sql; select rep, avg(cost) as AVERAGE from one group by rep <insert SQL procedure clause here> quit; The following output is desired:

REP AVERAGE ---------- --------- SMITH 400 Which SQL procedure clause completes the program and generates the desired output?

Question

Given the SAS data set ONE:

ONE REP COST -------- ------- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted:

proc sql; select rep, avg(cost) as AVERAGE from one group by rep <insert SQL procedure clause here> quit; The following output is desired:

REP AVERAGE ---------- --------- SMITH 400 Which SQL procedure clause completes the program and generates the desired output?

Accepted Answer

C. having avg(cost) > (select avg(cost) from one);

Answer

A. having avg(cost) < select avg(cost) from one);

Answer

B. where avg(cost) > (select avg(cost) from one);

Answer

D. where calculated average > (select avg(cost) from one);

Given the SAS data set ONE: ONE REP COST -------- ------- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted: proc sql; select rep, avg(cost) as AVERAGE from…