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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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.


by Jess at May 27, 2026, 07:11 PM

Limited Time Offer

25%

Off

Get Premium A00-215 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Andrew
3 days ago
C is definitely incorrect. No file path.
upvoted 0 times
...
Nenita
9 days ago
B uses the wrong order for libname.
upvoted 0 times
...
Dacia
14 days ago
I feel B is misleading.
upvoted 0 times
...
Phillip
19 days ago
D has a space in the path. That's wrong.
upvoted 0 times
...
Maryann
24 days ago
A seems correct, but what about D?
upvoted 0 times
...
Roy
29 days ago
I think it's A.
upvoted 0 times
...
Amie
1 month ago
C) doesn't even point to the right file format!
upvoted 0 times
...
Avery
1 month ago
Wait, can you really use .xlsx like that? Seems off.
upvoted 0 times
...
Rikki
1 month ago
D) has a typo in the path, so it can't be right.
upvoted 0 times
...
Glory
2 months ago
I think B) is actually the right one.
upvoted 0 times
...
Lashaunda
2 months ago
A) is the correct syntax for the libname statement.
upvoted 0 times
...
Francene
2 months ago
I thought the LIBNAME should always reference the workbook correctly, so maybe B is the right choice since it uses "xlsx" properly.
upvoted 0 times
...
Latricia
2 months ago
I feel like option D is close, but I think there’s an issue with the space in the file path.
upvoted 0 times
...
Krystina
2 months ago
I remember practicing a similar question where the LIBNAME was assigned first, but I can't recall if the file path needs quotes or not.
upvoted 0 times
...
Antione
3 months ago
I think the correct answer might be A, but I'm not entirely sure about the syntax for the LIBNAME statement.
upvoted 0 times
...

Save Cancel