A00-215 practice question 1 of 15
Which statement is true regarding the XLSX engine in the LIBNAME statement?
Full set: 78 questionsThe 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
Keep practicing
Take the free A00-215 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-215 practice questions
- Question 2Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?
- Question 5Which PROC SORT option allows you to create an output data set of the sorted data?
- Question 6Which LABEL statement has correct syntax?
- Question 8Which PROC PRINT step correctly displays only the first 10 observations in the data set?
- Question 12How does SAS display missing values?
- Question 13Which step temporarily assign a format to the sales variable?
