White space in file path using pipe

[max101]

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!

[Jagadishkatam]

could you please try to specify a single quote inside the double quotes of the file path, something like below

" 'D:\7Zip Standalone\7za.exe' "

[KevinViel]

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