SAS_Institute
A00-211 · Question #266
A00-211 Question #266: Real Exam Question with Answer & Explanation
The correct answer is A. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet. See the full explanation below for the reasoning.
Question
A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata. What will happen?
Options
- AA second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet
- BA second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
- CThe program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
- DThe program will produce an error message indicating that the exceldata.xlsx workbook already
Community Discussion
No community discussion yet for this question.