topic Re: How to zip an excel file and send it through an automated email using SAS EG 8.2 in SAS Programming

How to zip an excel file and send it through an automated email using SAS EG 8.2

radappan — Thu, 22 Apr 2021 14:08:33 GMT

Hi,

I have a report automated in SAS DI Studio but it's too large to send by an automated email. Can one of the users please assist me to zip this report and then send though an auto email.

Thanks.

Re: How to zip an excel file and send it through an automated email using SAS EG 8.2

Kurt_Bremser — Thu, 22 Apr 2021 14:15:17 GMT

If you already have a .xlsx file, there's not much sense in zipping it again. It is already a ZIP archive of XML data.

Instead of sending files in email, consider setting up a repository from which others can download the data with SFTP.

Re: How to zip an excel file and send it through an automated email using SAS EG 8.2

radappan — Thu, 22 Apr 2021 14:20:56 GMT

Hi KurtBremser,

A repository has already been set up for this but the user needs the report to be send by email but I am getting an insufficient memory error.

Thanks.

Re: How to zip an excel file and send it through an automated email using SAS EG 8.2

Kurt_Bremser — Thu, 22 Apr 2021 14:31:31 GMT

"Report" usually means something that is a few pages in size, and contains overview data to be read by a user.

Something that cracks the memory barriers while processing it looks like raw data, not a report. For data, simply export to a csv file and zip that.

You can do this in one step like this:

filename outzip zip '/folders/myfolders/class.zip';

data _null_;
set sashelp.class;
file outzip(class.csv) dlm=',';
if _n_ = 1 then put "name,sex,age,height,weight";
put name sex age height weight;
run;

filename outzip clear;