SAS_Institute
A00-202 · Question #11
Given the following SAS program: proc sql; select product, type, sum(sales) as revenue SAS A00-202 Exam from one group by product, type; quit; Which one of the following clauses should be added to…
The correct answer is C. order by 1, 3 desc. See the full explanation below for the reasoning.
Question
Given the following SAS program:
proc sql; select product, type, sum(sales) as revenue SAS A00-202 Exam from one group by product, type; quit; Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?
Options
- Aorder by product, desc revenue
- Border by 1, 3
- Corder by 1, 3 desc
- Dorderby product, revenue desc
How the community answered
(29 responses)- A7% (2)
- B10% (3)
- C79% (23)
- D3% (1)
Community Discussion
No community discussion yet for this question.