A00-215 practice question 1 of 15

Which statement is true regarding the XLSX engine in the LIBNAME statement?

Full set: 78 questions
Answer options
A: The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.
B: The XLSX engine can road and write data in Microsoft Excel workbooks. Correct answer
C: The XLSX engine can road Microsoft workbooks with both XLSX and XLS extensions
D: The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement
Correct Answer:
B. The XLSX engine can road and write data in Microsoft Excel workbooks.
Explanation

The correct answer is B: The XLSX engine can read and write data in Microsoft Excel workbooks. This functionality allows SAS users to directly access and manipulate data stored in Excel files using the .xlsx extension. The XLSX engine does not automatically concatenate individual worksheets; instead, each worksheet is accessed separately. Also, it specifically works with files that have the .xlsx extension, not the older .xls format, thus eliminating option C. Option D is incorrect because the XLSX engine requires the correct file extension (.xlsx) in the LIBNAME statement to properly identify and interact with Excel files.
Reference: SAS documentation on LIBNAME statement for XLSX engine: SAS Support: LIBNAME Statement

Scroll to Top