Given the data set shown in the left, the SAS program on the right is submitted.
Which program will result in the identical report?
A00-212 Exam QuestionsBrowse all questions from this exam
A00-212 Exam - Question 22
Show AnswerHide Answer
Correct Answer: AD
The given SAS program generates a table with distinct ClientID and Name values, sorted by ClientID in ascending order. To achieve the same result, the program must drop the Sales column and sort by ClientID. Option A correctly sorts the data by ClientID while dropping the Sales column, without using the nodupkey option, which matches the behavior of the SQL query in the given program.
Discussion
1 commentAidan_89Option: B
Jan 31, 2019Option B is correct, default sort is ascending not descending