topic Re: Quoting directory path in filename catd pipe 'dir "c:\test" /a-d /b /s'; in SAS Programming

Quoting directory path in filename catd pipe 'dir "c:\test" /a-d /b /s';

DMoovendhan — Thu, 07 Feb 2013 20:01:30 GMT

Quoting the directory path in below statement, when its supplied as a macro variable,

path in

%let logdir = c:\test;

%let filot = %str(%'dir %")&logdir%%str(%" /a-d /b /s%');

%put &filot;

filename catd pipe &filot ;

filename catd pipe %nrstr(&filot);

'%put' resolves &filot to the exact value in filename statement, but none other statements gets resolved.

D Moovendhan

DBailey — Thu, 07 Feb 2013 20:19:36 GMT

try this:

filename catd pipe "&filot" ;

Tom — Thu, 07 Feb 2013 20:31:38 GMT

%let logdir = c:\test;

%let command = dir "&logdir" /a-d /b /s ;

%put &command;

filename catd pipe %sysfunc(quote(&command));

DMoovendhan — Fri, 08 Feb 2013 05:32:32 GMT

Thank you Bailey, I have tried this, but it doesn't work...

DMoovendhan — Fri, 08 Feb 2013 05:33:56 GMT

Thank you Tom this was more helpful.. Now I know new function quote..

Tom — Fri, 08 Feb 2013 05:53:23 GMT

You can also just double the internal quotes yourself.

filename catd pipe "dir ""&logdir"" /a-d /b /s ";