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…
Sign in or unlock A00-211 to reveal the answer and full explanation for question #266. The question stem and answer options stay visible for context.
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
Unlock A00-211 to see the answer
You've previewed enough free A00-211 questions. Unlock A00-211 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.