Hello everyone, i'm trying to create a SAS program for zipping and encrypting a csv file, which i need to send via email. I used the routine for generate a random password, and found the routine to 7zip the file, but i can't apply password to the code: data _null_; *Path to winzip program; zipexe='"C:\Program Files\7-Zip\7z.exe" a -tzip -p&Pwd'; *Zip file name; zipfile="C:\SASOutputs\Mail\RSK_001_Pratiche_A_Rischio_All.zip"; *File to be zipped; file="C:\SASOutputs\Mail\RSK_001_Pratiche_A_Rischio_All.csv"; *Full cmd line to be passed to command line. It embeds the quotes for paths with spaces; cmd = zipexe ||' "'|| zipfile ||'" "'|| file ||'"' ; *Execute command; call system(cmd); run; It only works if i use a fixed value instead of &Pwd zipexe='"C:\Program Files\7-Zip\7z.exe" a -tzip -pPASSWORD'; How can i use my &Pwd variable to set a random password to the zip? Thanks in advance Gianluca
... View more