Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam A00-212 topic 1 question 103 discussion

Actual exam question from SAS Institute's A00-212
Question #: 103
Topic #: 1
[All A00-212 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
mhminkov
2 years, 8 months ago
LEVEL MAX 2 30 3 30
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...