Question

The following SAS program is submitted: proc sort data = work.employee; by descending fname; proc sort data = ; by descending fname; data work.empdata; merge work.employee ; by fname; run; Why does the program fail to execute?

a) Missing dataset in the second PROC SORT
b) Incorrect use of the DESCENDING keyword
c) Missing BY statement in the second PROC SORT
d) Mismatched variable names in the MERGE statement

Answer 1

The program fails to execute due to the missing dataset in the second PROC SORT.

Step-by-step explanation:

The program fails to execute due to the missing dataset in the second PROC SORT.

The correct syntax for the PROC SORT statement should include the name of the dataset after the 'data =' keyword.

In this case, the correct statement should be 'proc sort data=work; by descending fname;'