topic Re: How to export multiple datasets when using SAS Add-Ins and Excel in SAS Programming

How to export multiple datasets when using SAS Add-Ins and Excel

carlos_jimenez — Fri, 28 Oct 2022 21:34:26 GMT

Hello.

The situation that I am facing is as follow. I am running a code inside Excel using SAS Add-Ins. This code produce three datasets. I am having difficulties exporting/printing each dataset to its own tab. Thoughts?

Example, redirect the output for Asia and Europe to individual tabs in Excel.

data cars;
set sashelp.cars;
run;

proc print data=SASHELP.CARS(where=(Origin='Asia'));
;
run;

proc print data=SASHELP.CARS(where=(Origin='Europe'));
;
run;

Re: How to export multiple datasets when using SAS Add-Ins and Excel

ballardw — Fri, 28 Oct 2022 20:06:12 GMT

As a minimum you should include the code that you are running. Then we have a chance to follow the attempt and may be able to provide comments.

Better would be to show the Log from SAS when running your program to see if SAS is seeing potential problems.

Re: How to export multiple datasets when using SAS Add-Ins and Excel

SASKiwi — Mon, 31 Oct 2022 02:27:57 GMT

You don't have to code to do that. Just click on the Data icon in the SAS tab and click the Browse button. Select library SASHELP and dataset CARS and select Open. The default sheet name stays as Sheet1 but you can just change it.

Re: How to export multiple datasets when using SAS Add-Ins and Excel

carlos_jimenez — Mon, 31 Oct 2022 03:01:52 GMT

That was just an example since I cannot share privately owned data. The task is to export any resulting dataset to its respective tab.

Re: How to export multiple datasets when using SAS Add-Ins and Excel

SASKiwi — Mon, 31 Oct 2022 03:18:31 GMT

This works for any dataset of your choosing, not just those in the SASHELP library. You can specify sending your data to a new sheet and provide the name: