topic Re: how to export the datasets to as excel file in different tab in New SAS User

how to export the datasets to as excel file in different tab

kojuramesh — Thu, 13 Jun 2024 16:09:17 GMT

code to export two output datasets as excel file into different tabs.

for example: output datasets Check_transactions and Cash_transactions export as Transactions excel file to local C:\Users\kojuramesh\Documents

Thanks

Re: how to export the datasets to as excel file in different tab

ballardw — Thu, 13 Jun 2024 16:17:53 GMT

Not with PROC Export and likely not with any Export data widget or task.

ODS and Proc print:

ods excel file="x:\example.xlsx" options(sheet_interval='PROC');

proc print data=sashelp.class noobs;
run;

proc print data=sashelp.cars noobs;
run;

ods excel close;

There are other valid sheet_interval options but this is likely to work for this sort of thing IF the data sets are small enough to fit on a single sheet.

Re: how to export the datasets to as excel file in different tab

Kurt_Bremser — Thu, 13 Jun 2024 18:38:12 GMT

libname exc xlsx "C:\Users\kojuramesh\Documents\transactions.xlsx";

proc copy in=work out=exc;
select check_transactions cas_transactions;
run;

libname exc clear;