Question 27: The following SAS program is submitted:

 proc sort data = work.employee;

 by descending fname;

 proc sort data = work.salary;

 by descending fname;

 data work.empdata;

 merge work.employee

 work.salary;

 by fname;

 run;

 Why does the program rail to execute?

1. The SORT procedures contain invalid syntax.
2. Get all Questions and Answer from here
3. You need to have paid subscription to access all questions
4. Thanks for considering Python Certification Material

 Correct Answer : 4

 Exp : You should have the DESCENDING option in the BY statement in both the PROC SORT steps and the DATA STEP. If you omit the DESCENDING option in the DATA STEP, you generate error

 messages about improperly sorted BY Variable.

 PROC SORT DATA=states;

 BY state_name;

 PROC SORT DATA=vehicles;

 BY state_name;

 DATA widedata;

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