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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.