ZIPPING A FILE FROM SAS 1

[depacho]

Hi,

I am producing a huge number of big files exported to different file types (mainly xls or CSV) and I was wondering if there is any way to produce these files already zipped directly from SAS instead of having to go and zip one by one (they go to different places so it is not zipping all in one file).


Thnak you.

 

[ChrisW75]

two possible methods, which are actually very similar. You can use most Zip programs (PKZIP, WInzip etc) from a command line. For instance, in a job script I used to run in windows, we used this:-

pkzip25 -add -max -directories -header %zipdest%.zip  e:\%client%\%jobno%\ *.*

So, you could have a dos script (or whatever environment you are working in) do the work for you.

If you are set on doing it via SAS, the other option is to use the X command. I would look this up in the doco if I were you, as there is alot of system specific stuff there. Personally I'd rather do it from a script (you can set the same script to run your SAS program) as it's a bit more obvious what is happening, SAS can be a little oblivious at times to the results of your host process (ie it might fail and there's nothing in your log to say so). I've used the X command before (no examples on me I'm afraid) and you can pass it macro variables etc etc, so it can be pretty powerful like that, but you really need to make sure that you pick up the return codes after the X process completes and check for errors.

 

[depacho]

Thank you ChrisW75