SAS_Institute
A00-211 · Question #266
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…
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
How the community answered
(23 responses)- A74% (17)
- B9% (2)
- C13% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.