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

[carlos_jimenez]

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;

[ballardw]

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.

[SASKiwi]

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.

[carlos_jimenez]

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

[SASKiwi]

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: