topic Re: Multiple Macro Runs in New SAS User

Multiple Macro Runs

GallagherML — Tue, 15 Dec 2020 09:34:12 GMT

Hi everyone,

I am trying to run a macro with two variables Test1 and Test2.

%macro TestMacro (Test1=,Test2=,Num=);

DATA WORK.TestDt&Num;
Mean=MEAN(&Test1,&Test2);
RUN;

%mend TestMacro;

%TestMacro (Test1=19,Test2=20,Num=1);
%TestMacro (Test1=16,Test2=19.8,Num=2);
%TestMacro (Test1=18.9,Test2=17.6,Num=3);

It works fine when I only run it once. However, the macro stops after the first run, even though there are two left that I included at the same time. I don't know if that is what is supposed to happen, or if I haven't figured out how to run multiple macros at the same time yet. Clarification would be great!

Thanks y'all

Re: Multiple Macro Runs

PeterClemmensen — Tue, 15 Dec 2020 09:43:48 GMT

Works for me without errors. Post your log please?

Re: Multiple Macro Runs

Kurt_Bremser — Tue, 15 Dec 2020 10:08:02 GMT

Works:

 73         %macro TestMacro (Test1=,Test2=,Num=);
 74         
 75         DATA WORK.TestDt&Num;
 76         Mean=MEAN(&Test1,&Test2);
 77         RUN;
 78         
 79         %mend TestMacro;
 80         
 81         %TestMacro (Test1=19,Test2=20,Num=1);
 
 NOTE: The data set WORK.TESTDT1 has 1 observations and 1 variables.
 NOTE:  Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit):
       real time           0.00 seconds
       cpu time            0.01 seconds
       
 
 82         %TestMacro (Test1=16,Test2=19.8,Num=2);
 
 NOTE: The data set WORK.TESTDT2 has 1 observations and 1 variables.
 NOTE:  Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 83         %TestMacro (Test1=18.9,Test2=17.6,Num=3);
 
 NOTE: The data set WORK.TESTDT3 has 1 observations and 1 variables.
 NOTE:  Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit):
       real time           0.00 seconds
       cpu time            0.00 seconds

Please post your log, using the </> button as I did.

Re: Multiple Macro Runs

Astounding — Tue, 15 Dec 2020 14:59:54 GMT

You might be looking in the wrong place. The data set TestDt1 never changes. The second run creates TestDt2, it doesn't replace TestDt1.

Re: Multiple Macro Runs

hswdl01 — Tue, 15 Dec 2020 23:05:36 GMT

The code you posted seems to be working fine for me and I don't see anything in the code to suggest it wouldn't work. Did you get any warnings or errors in your log?

Re: Multiple Macro Runs

sdevenny — Wed, 16 Dec 2020 04:57:28 GMT

The code worked for me, just make sure that you're checking the dropdown menu under output (if you are on Studio, not sure how this works for other versions). Or, you could include a PROC PRINT in the macro, and then it should print all 3 means as different tables.