topic Exporting excel in New SAS User

Exporting excel

Jianan_luna — Sat, 11 Jul 2020 20:58:34 GMT

When I do the quiz from SAS programming 1 course, I cannot make sense this question. Can anyone help me this question?

Re: Exporting excel

PaigeMiller — Sat, 11 Jul 2020 21:18:43 GMT

The output of the code is CLASS_LIST, which is a SAS data set (which they call a SAS table).

Nothing has happened to make this an Excel file. If they tried to create MYLIB.CLASS_LIST, that would be included in the Excel file.

Re: Exporting excel

Tom — Sat, 11 Jul 2020 22:34:57 GMT

That is a terribly worded question. Did you have to pay to access those questions?

The program will not create any OUTPUT files.

The LIBNAME statement sets up the libref MYLIB pointing to the specified file, but nothing it written until you use it.

The data step will create a SAS dataset in the WORK library (unless you have defined the USER libref and/or used the USER option). I would not call that an OUTPUT file.

Re: Exporting excel

Kurt_Bremser — Sun, 12 Jul 2020 05:09:16 GMT

The question illustrates a common mistake: defining a library, but then missing to use it in the following code.

Defining a library with the XLSX engine does not create anything; only when data is written to this library, the Excel file will be created if it did not yet exist.