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

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