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 quit; The following output is desired: REP AVERAGE ---------- --------- SMITH 400 Which SQL procedure clause completes the program and generates the desired output?

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

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

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

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

SAS_Institute

A00-212 · Question #47

A00-212 Question #47: Real Exam Question with Answer & Explanation

Sign in or unlock A00-212 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.

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?

Options

Ahaving avg(cost) < select avg(cost) from one);
Bwhere avg(cost) > (select avg(cost) from one);
Chaving avg(cost) > (select avg(cost) from one);
Dwhere calculated average > (select avg(cost) from one);

Unlock A00-212 to see the answer

You've previewed enough free A00-212 questions. Unlock A00-212 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock A00-212 - $49.99 / 30 days Sign in

Full A00-212 Practice