Hi all
I have been using ODS Package to create zip files but now find myself needing to encrypt the files within.
I have used the code below successfully but only if adding one file - I can't get it to work when adding two.
data _null_ ;
zipexe = '"C:\Program Files (x86)\WinZip\WINZIP32.exe" -min -a -s';
pw="&pwdit";
zipfile="C:\test.zip";
file="C:\test 1.pdf";
cmd=zipexe || pw || ' ' || zipfile || ' ' || files ;
putlog "NOTE-Processing command " cmd ;
call system( cmd ) ;
run;
Can anyone help with adding multiple files? The filenames will have spaces in them hence the need for double quotes.
Or if I create the zip file using ODS package, does anyone know if I can then use the winzip command line utility to open an existing zip file and apply the encryption?
Thanks in advance.
Best solution: get rid of the ****ing blanks in filenames. Use underscores instead.
Next best solution:
file='"C:\test 1.pdf"';
(encapsulate double quotes with single quotes, so the double quotes end up in the data step variable)
If you need to process a list of files, either use wildcard characters or make sure that every single filename has the double quotes.
Best solution: get rid of the ****ing blanks in filenames. Use underscores instead.
Next best solution:
file='"C:\test 1.pdf"';
(encapsulate double quotes with single quotes, so the double quotes end up in the data step variable)
If you need to process a list of files, either use wildcard characters or make sure that every single filename has the double quotes.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.