A00-215 practice question 2 of 15

Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?

Full set: 78 questions
Answer options
A: Ods excel=’ c : \report. xlsx’ style=analysis; Correct answer
B: Ods excel workbook=’ report. xles’ analysis;
C: Ods excel=’ c : \report. xlsx’ / analysis;
D: Ods excel file =’c \report.xlsx’ styleanalysis;
Correct Answer:
A. Ods excel=’ c : \report. xlsx’ style=analysis;
Explanation

The 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

Scroll to Top