Hello,
I would like to unzip a file via
%let filename = file.bz2;
%let b = D:\rawdata\zipped\&filename;
filename pipedir pipe %sysfunc(quote(D:\7ZipStandalone\7za.exe e "&b" -y -so));
Data mydat;
Infile pipedir;
file "D:\rawdata\zipped\unzippedfile.log";
input;
put _infile_;
run;
This works so far. A problem arises, if the folder name contains white space.
So if the path changes to "D:\7Zip Standalone\7za.exe" the code no longer works.
I tried using the quote, unquote and str functions (also macro versions '%') so far without success.
Thanks for helping!
This caused issues for me. I had IT create a environmental variable (with no spaces). A colleague suggested that I use PROGRA~1 instead of writing the full path: https://communities.sas.com/t5/SAS-Programming/Windows-and-pipe-with-spaces-in-the-path-file-name/m-....
HTH,
Kevin
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.