Question 10 :

 The SAS data set Employee_info is listed below.

 employee bonus

 2542      100.00

 3612      133.15

 2198      234.34

 2198      111.12

 The following SAS program is submitted:

 proc sort data=employee_info;   

 (insert BY statement here)

 run;

 Which one of the following BY statements completes the program and sorts the data in sequential order bydescending bonus values within ascending employee values?

  1. by descending bonus employee;
  2. Get all Questions and Answer from here
  3. You need to have paid subscription to access all questions
  4. Thanks for considering SAS Certification Material

 Correct Answer : 3

 Exp : You use the keyword DESCENDING in a BY statement to specify that data will be sorted by values in descending order. The DESCENDING keyword applies to the variable that is

 listed immediately after it.

You can access to full explanation to question and answer from this page.