Export multiple datasets to multiple excel files

[shikpop]

Hi Guys,

I have 18 datasets in my output window and these 18 datasets has to be attached in excel format on outlook to 18 different people.

Can you please guide me as to how I can do this?

Thanks

[RW9]

How to create Excel files:

https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

Or preferred if your on 9.4:

https://support.sas.com/resources/papers/proceedings17/0169-2017.pdf

How to email:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002058232.htm

I would advise against the use of email to send datafiles.

[shikpop]

Hi Thanks for such a quick reply!

I've gone through this article but there is one thing I fail to understand that if i want different workbooks for each output dataset which method should I go for?

And is there an option where the xlsx file i create can be sent via mail?

Thanks

[Kurt_Bremser]

If you use proc export, each proc export call will create a new file (=workbook).

Once files are created, filename email in SAS allows to attach files.

As already advised, sending datafiles per email is not good. Providing files for download with sftp(SSH) or https is the way to go.