topic Re: Export multiple datasets to multiple excel files in SAS Enterprise Guide

Export multiple datasets to multiple excel files

shikpop — Thu, 22 Nov 2018 09:37:36 GMT

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

Re: Export multiple datasets to multiple excel files

RW9 — Thu, 22 Nov 2018 09:52:05 GMT

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.

Re: Export multiple datasets to multiple excel files

shikpop — Thu, 22 Nov 2018 09:57:59 GMT

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

Re: Export multiple datasets to multiple excel files

Kurt_Bremser — Thu, 22 Nov 2018 10:08:14 GMT

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.