topic Re: X Windows Command - Cd to a folder directory with "&" in SAS Programming

X Windows Command - Cd to a folder directory with "&"

danielh — Tue, 03 Jan 2012 05:00:04 GMT

I have a quick SAS question regarding the “x” command.

I need to access the following directory with cmd to createa list of csv files in a particular folder.

%letDrive=M:;

%letPath=%nrstr(Clients\Reporting\01Data\A & B\Extracts);

x "&drive.";

x "cd&path.";

x "dir *.csv >xlsFileList.txt";

Unfortunately, this failed because of the “&”sign in the directory.

Testing with cmd directly, I found that entering the following command works: cd Clients\Reporting\01Data\"A & B"\Extracts.

Logically we followed this by running the SAScommand

x ‘cd Clients\Reporting\01 Data\”A & B”\Extracts.’;

Once again, this failed. I have been stuck on this for the past hour. It would be much appreciated if someone could provide a solution.

Thanks

Daniel

X Windows Command - Cd to a folder directory with "&"

Patrick — Tue, 03 Jan 2012 05:22:40 GMT

I believe this is only about correct quoting. Below code worked for me:

options noxwait;
%let path=%nrbquote(C:\temp\"this & that");
data _null_;
x "mkdir &path";
x "dir > &path\dirlist.txt";
run;

Re: X Windows Command - Cd to a folder directory with "&"

Tom — Tue, 03 Jan 2012 15:27:16 GMT

Use double quote characters as your outside quotes and SAS will expand the macro variable references.

Use the QUOTE function to handle doubling the embedded quotes.

%let Drive=M:;

%let Path=%nrstr(Clients\Reporting\01Data\A & B\Extracts);

x %sysfunc(quote(dir "&drive\&path" >xlsFileList.txt));

Simplified command.

Re: X Windows Command - Cd to a folder directory with "&"

chang_y_chung_hotmail_com — Tue, 03 Jan 2012 18:14:33 GMT

Your path is not to be resolved by an explicit or implicit %eval(). Thus you don't need to macro quote the singleton ampersand character at all. The ampersand has to be hidden from the cmd.exe shell though, since it is a command separator to the interpreter (see msdn article). The following worked fine on my sas running on a windows 7:

   %let drive = c:;
   %let path = /temp/a & b;
   x "&drive & cd ""&path"" & dir *.csv > list.txt";

Re: X Windows Command - Cd to a folder directory with "&"

Ksharp — Wed, 04 Jan 2012 02:36:11 GMT

Another way is to make a .bat file.

%let Drive=c: ;
%let Path=\temp\A & B\Extracts ;

data _null_;
 file 'c:\x.bat';
 a='cd "'||"&drive&path"||'"';
 put a;
 b='dir *.pdf > x.txt';
 put b;
run;
options noxwait;
x 'c:\x.bat';
x 'del c:\x.bat';

Ksharp