Executing a X Command with macro

Singham20 — Mon, 11 Sep 2017 17:52:28 GMT

Hi everyone!

I am trying to copy and rename a bunch of files on my computer and thought X commands is the way to go. I tried it and it worked perfectly however when I put in a Macro to do this it does not work. it just saves the first file with the name stated and does not replace the "&name" with name given. Here is what I have written so far:

%FAST(2017,Carry,05T);

%macro FAST(YEAR,SURVEY,MO);

X "copy ""C:\TestSASCode\&YEAR\&SURVEY\&MO\test.DAT"" ""C:\TestSASCode\SAS\&SURVEY_&YEAR_&MO_2017-carrier.DAT"" ";

%mend;

%FAST(2017,Carry,01T);

%FAST(2017,Carry,02T);

%FAST(2017,Carry,03T);

I know it looks like I do not need the &Year and &survey because they are the same however I will be doing this for different year and surveys too. I just wanted the question to be simple.

What do you guys think I should do?

Thank you!

Re: Executing a X Command with macro

Reeza — Mon, 11 Sep 2017 17:57:08 GMT

Add periods after the macro variables.

If you run the code with the following the log will have more information that helps with debugging.

options mprint symbolgen;

&SURVEY._&YEAR._&MO.

Re: Executing a X Command with macro

Singham20 — Mon, 11 Sep 2017 18:04:55 GMT

Thank you so much! I cannot believe I overlooked that.

topic Re: Executing a X Command with macro in SAS Programming

Executing a X Command with macro

Re: Executing a X Command with macro

Re: Executing a X Command with macro