SAS_Institute
A00-212 · Question #134
Given the following SAS program: proc sql; select product, type, sum(sales) as revenue from one group by product, type; quit; Which one of the following clauses should be added to the program to…
The correct answer is B. 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 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 1, 3
- Border by 1, 3 desc
- Corderby product, revenue desc
- Dorder by product, desc revenue
How the community answered
(30 responses)- A3% (1)
- B73% (22)
- C7% (2)
- D17% (5)
Community Discussion
No community discussion yet for this question.