SAS Training

SAS Certified Adv Programmer 130 Questions (49)

Given the following SAS data set ONE:

ONE 
LEVEL AGE
1     10
2     20
3     20
2     10
1     10
2     30
3     10
2     20
3     30
1     10

The following SAS program is submitted:

proc sql;
    select level, max(age) as MAX from one group by level having max(age) >
        (select avg(age) from one);
quit;

Which one of the following reports is generated?

A.

LEVEL AGE
2     20 
3     20

B.

LEVEL AGE
2     30 
3     30

C.

LEVEL MAX
2     20 
3     30

D.

LEVEL MAX
2     30
3     30

5 comments | Add One

Leave a Comment