Question

"Which of these programs creates a Microsoft Excel file?

a. ods excel file=""s:/workshop/output/ "";
proc print data= ;
run;
ods excel close;
b. libname mylib xlsx ""s:/workshop/output/ "";
data mylib.class_list;
set ;
run;
c. both
d. neither

Answer 1

Both programs (a) using ODS and PROC PRINT, and (b) using the libname reference with the XLSX engine, are used to create a Microsoft Excel file.

Step-by-step explanation:

The question asks which program creates a Microsoft Excel file. Option a uses the Output Delivery System (ODS) to create an Excel file with the PROC PRINT step, which prints the data to the specified Excel file before closing it with 'ods excel close'.

Option b sets up a libname reference to an Excel file using the XLSX engine and creates a dataset in that Excel file with the 'data' step. Therefore, the correct answer is c. both.