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

[kojuramesh]

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

[ballardw]

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.

[Kurt_Bremser]

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

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

libname exc clear;