topic Lesson 6 Exporting Data in Programming 1 and 2

Lesson 6 Exporting Data

brianhoops1 — Mon, 16 Oct 2023 21:49:00 GMT

I'm stuck on the Exporting Data to an Excel Workbook on Lesson 6 SAS Programming 1.

On the Demo, it asks the following:

Add a LIBNAME statement to create a library named xlout that points to an Excel file named southpacific.xlsx.
Note: Use &outpath to provide the path to the file.

libname xlout xlsx "&outpath/southpacific.xlsx";

I have added xlout for this step and step 6. When I run the program, I receive the error:

In the previous steps, we were instructed to add the Macro variable for output, but that does not seem to be working. Any advice on how to proceed?

Tom — Mon, 16 Oct 2023 21:54:35 GMT

You are going to need more code than that to EXPORT data to an XLSX file.

First you have to have defined the macro variable outpath properly.

Second you have to have some code that will write something into the new XLSX file (actually do the exporting).

Once that is done then perhaps there will be sheet named South_Pacific in the XLSX file that the libref XLOUT is pointing to.

ballardw — Mon, 16 Oct 2023 22:22:30 GMT

Show the code where you assign a value to the macro variable outpath.

User defined macro variables like that do not persist across sessions. So if you did that in a different SAS session you need to do it again.