topic zip data ???????? in SAS Procedures

zip data ????????

sassharp — Wed, 22 Feb 2012 21:58:59 GMT

I need to zip big csv and then to attach to email in sas. any info please?

zip data ????????

FriedEgg — Wed, 22 Feb 2012 22:11:14 GMT

*if you use windows you may want to use the following options;

*options noxwait xsync;

x 'zip myzipfile.zip /file/to/zip.csv';

filename eml email to="somone@work" attach=("myzipfile.zip" ct="application/zip") subject="Attached File";

data _null_;

file eml;

put "Hi," / / "You zip file is attached" / "Thanks," / "Me";

run;

zip data ????????

sassharp — Wed, 22 Feb 2012 22:53:37 GMT

using EG in winds

zip data ????????

FriedEgg — Wed, 22 Feb 2012 23:16:38 GMT

What EG connecting to is what matters with the code I posted.

zip data ????????

Doc_Duke — Thu, 23 Feb 2012 14:06:36 GMT

Actually, it does matter. For Enterprise Guide use, the "x" command is disabled, by default. If SASHARP can get the local admin to allow the x command, then FriedEgg's code will work.

You could than also put the x-command (alone) in a code node and then use the EGuide e-mail task to send it out.

Doc Muhlbaier

Duke

zip data ????????

sassharp — Thu, 23 Feb 2012 16:11:38 GMT

Doc Muhlbaier

??put the x-command (alone) in a code node and then use the EGuide e-mail task to send it out??

can you elaborate more?

zip data ????????

FriedEgg — Thu, 23 Feb 2012 16:38:08 GMT

Thanks Doc@Duke, I often forget about this default.

sassharp, you can check for this using:

proc options option=xcmd; run;

In your log you should see something to the effect of:

XCMD The X Command is valid in this SAS session

This means you can run my example code.

When Doc@Duke says use the EGuide email task to send it out he means to do the following:

Lets say you have your SAS dataset.

You choose to use the EGuide task to export this dataset to CSV. In this step save the results to your local computer as yourfile.csv

In EGuide in the process flow you now have that CSV file available. Right-click on it and you will see a option like Send To -> E-mail Recipient as a Step in Project...

Select the option and the EGuide task window opens, there is a option here to 'Compress all files' You will want to check this option and probably the additoonal option to rename the compressed file to something.

Now you can email your zipped file, code free.

zip data ????????

Doc_Duke — Thu, 23 Feb 2012 16:49:28 GMT

you can select program --> new program to create a task that is code that you create. That is where you could put the x-command.

However, if you just want to zip the file for e-mail purposes, the directions that FriedEgg provided are perfect.

Doc Muhlbaier

Duke

zip data ????????

sassharp — Thu, 23 Feb 2012 17:00:55 GMT

need to automate the process. already used EGuide email Right-click method.

thanks

zip data ????????

Doc_Duke — Thu, 23 Feb 2012 17:30:37 GMT

if you "e-mail recipient as a step in the project" (emphasis added), that will allow you to send the e-mail by scheduling the project, so it provides the automation piece.