Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAS A00-215 Exam - Topic 9 Question 60 Discussion

Which program assigns the library reference exlib to the CLASS. XLSX workbook and displays the CLASS_TEST worksheet?
D) libname exlib xlsx 'c: \class.xlsx'; proc print data=exlib.class_test; run;
A) libname xlsx exlib 'c:\class.xlsx'; proc print data=xlsx.class_test; run;
B) libname exlib xlsx 'c:\class.xlsx'; proc print data=class_test.xlsx; run;
C) libname exlib xlsx 'c:\class'; proc print data=exlib.class_test.xlsx; run;

SAS A00-215 Exam - Topic 9 Question 60 Discussion

Actual exam question for SAS's A00-215 exam
Question #: 60
Topic #: 9
[All A00-215 Questions]

Which program assigns the library reference exlib to the CLASS. XLSX workbook and displays the CLASS_TEST worksheet?

Show Suggested Answer Hide Answer
Suggested Answer: D

The correct answer is option D, which uses the LIBNAME statement correctly to assign a library reference to an Excel workbook and specifies the correct syntax for accessing a worksheet within that workbook. The syntax for this option is:

libname exlib xlsx 'c:class.xlsx';

proc print data=exlib.class_test;

run;

This code snippet assigns the library reference exlib to the Excel workbook located at c:class.xlsx using the XLSX engine. The PROC PRINT step is then used to display the contents of the worksheet named CLASS_TEST within that workbook. The library reference exlib combined with the dataset name class_test (following the .) correctly specifies the worksheet to be printed. The other options (A, B, C) are incorrect due to various reasons: incorrect syntax for the LIBNAME statement, incorrect specification of the dataset to be printed, and incorrect path specifications. Reference: SAS 9.4 Guide to Software Updates.


Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel