Discuss SAS A00-215 Exam Topic 9 Question 60

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

Alibname xlsx exlib 'c:\class.xlsx';
proc print data=xlsx.class_test;
run;

Blibname exlib xlsx 'c:\class.xlsx';
proc print data=class_test.xlsx;
run;

Clibname exlib xlsx 'c:\class';
proc print data=exlib.class_test.xlsx;
run;

Dlibname exlib xlsx 'c: \class.xlsx';
proc print data=exlib.class_test;
run;

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.

Get Premium A00-215 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

19 comments · newest first

Alethea 28 days ago

I hope we get this right!

Joana 1 month ago

D is confusing with that space.

Lavera 1 month ago

I agree, A is the best choice.

Joaquin 1 month ago

A is clear and straightforward.

Andrew 2 months ago

C is definitely incorrect. No file path.

Nenita 2 months ago

B uses the wrong order for libname.

Dacia 2 months ago

I feel B is misleading.

Phillip 2 months ago

D has a space in the path. That's wrong.

Maryann 2 months ago

A seems correct, but what about D?

Roy 2 months ago

I think it's A.

Amie 3 months ago

C) doesn't even point to the right file format!

Avery 3 months ago

Wait, can you really use .xlsx like that? Seems off.

Rikki 3 months ago

D) has a typo in the path, so it can't be right.

Glory 3 months ago

I think B) is actually the right one.

Lashaunda 3 months ago

A) is the correct syntax for the libname statement.

Francene 4 months ago

I thought the LIBNAME should always reference the workbook correctly, so maybe B is the right choice since it uses "xlsx" properly.

Latricia 4 months ago

I feel like option D is close, but I think there’s an issue with the space in the file path.

Krystina 4 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.

Antione 4 months ago

I think the correct answer might be A, but I'm not entirely sure about the syntax for the LIBNAME statement.

SAS A00-215 Exam - Topic 9 Question 60 Discussion