A00-215 practice question 2 of 15
Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?
Full set: 78 questionsThe correct answer is A: Ods excel='c:\report.xlsx' style=analysis;. This syntax is correct for the ODS EXCEL statement in SAS, where you specify the path and filename, followed by the 'style' option to apply a specific style template to the output Excel file. The 'style=analysis' is used to set the output appearance according to the 'ANALYSIS' style template provided by SAS. Option B is syntactically incorrect and does not use the 'style' option correctly. Option C incorrectly places a slash which is not syntactically valid in this context, and Option D misses the equals sign and quotes which are necessary for correct syntax in SAS.
Reference: SAS documentation on ODS EXCEL statement: SAS Support: ODS EXCEL 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 1Which statement is true regarding the XLSX engine in the LIBNAME statement?
- 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?
