topic Re: White space in file path using pipe in SAS Programming

White space in file path using pipe

max101 — Wed, 10 Feb 2016 12:41:35 GMT

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 — Wed, 10 Feb 2016 16:21:24 GMT

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 — Mon, 25 Nov 2019 22:47:20 GMT

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-p/607133#M176401.

HTH,

Kevin