Question

"What does the following program create?

libname sales xlsx 'c:\mydata\ ';

data sales.q1_2018;
set sasdata.qtr1_2018;
run;
data sales.q2_2018;
set sasdata.qtr2_2018;
run;
a. two SAS tables: sales.q1_2018 and sales.q2_2018
b. two Excel workbooks: sales.q1_2018 and sales.q2_2018
c. two worksheets in the Excel workbook: midyear: q1_2018 and q2_2018
d. two worksheets in the Excel workbook: sales: q1_2018 and q2_2018

Answer 1

The provided code creates two SAS tables named sales.q1_2018 and sales.q2_2018, which correspond to two worksheets within an Excel file, due to the library reference established by the 'libname' statement.

Step-by-step explanation:

The program provided with the libname statement creates a library reference (alias) named 'sales' for the Excel file located at 'c:\mydata\ '. The 'data' steps then create two SAS tables: sales.q1_2018 and sales.q2_2018.

It does this by setting the source data sets (sasdata.qtr1_2018 and sasdata.qtr2_2018) and creating two separate datasets within the 'sales' library. Since the 'sales' library is associated with an Excel file thanks to the libname statement, it effectively creates two worksheets within the named Excel file. These worksheets are named q1_2018 and q2_2018.