topic Re: How to run a macro 60 times and put data into in one table? in SAS Programming

How to run a macro 60 times and put data into in one table?

XiaoyanZhao — Wed, 22 Apr 2015 20:56:13 GMT

Hi, Dear all

Please rescue me! I have a urgent request but don't know what to do with it.

I am running a macro 60 times, then put data into one table. I was thinking to use do loop to let it run 60 times and proc append them into 1 file. After searching for 1 hour, I am here. Can anyone kindly help me?

Many thanks

Hi, all I end up add a macro as below for running macro analysis 30 times to boostrap. Thank you all

%Macro doit;

%do i =1 %to 30;

%if i > 30 %then %do;

%analysis('01jan14'd,'31jan14'd, '01-01-2014','01-31-2014')

%end;

%mend;

Re: How to run a macro 60 times and put data into in one table?

LinusH — Wed, 22 Apr 2015 21:04:50 GMT

Not knowing what is behind the requirement is sounds like you are on the right track (depending on what your macro does).

Re: How to run a macro 60 times and put data into in one table?

art297 — Wed, 22 Apr 2015 21:15:22 GMT

I think you're on the right track, but you might want to include the proc append within the macro. That way you don't have to keep track of file names and might be able to reuse the same filename for all of the individual files your macro creates.

Re: How to run a macro 60 times and put data into in one table?

XiaoyanZhao — Wed, 22 Apr 2015 21:24:57 GMT

My macro would generate a table with 2 columns, one is from Jan, 2014 to Dec 2014 (once per month) as Time, one is the number that I wanted. But the result is ramdom. So I want to run it 60 times and ave the number that I wanted. Don't know how to write the execute macro 60 times in do loop code. Help me please........

Thanks

Hi, all

I end up add the macro in the code to execute macro analysis 30 time to bootstrap data for random selected results.

%Macro doit;

%do i =1 %to 30;

%if i > 30 %then %do;

%analysis('01jan14'd,'31jan14'd, '01-01-2014','01-31-2014')

%end;

%mend;

%DOIT

Re: How to run a macro 60 times and put data into in one table?

Reeza — Wed, 22 Apr 2015 22:26:34 GMT

Post a sample macro call, preferably a few. Or even your macro code.

You can generally use call execute within a a data step loop.

Re: How to run a macro 60 times and put data into in one table?

sbb — Wed, 22 Apr 2015 22:52:53 GMT

Suggest starting with available SAS.COM support / communities resources - Internet search might include argument:

macro do loop generate code site:sas.com

As has been suggested, post what doesn't work.

Also, consider SAS OPTIONS such as NODSNFERR NOVNFERR NOBYERR, if you intend to code one set / logic-path, otherwise look at using macro language logic involving %SYSFUNC(EXIST(<member_name>)) to control initial code-path.

Re: How to run a macro 60 times and put data into in one table?

XiaoyanZhao — Thu, 23 Apr 2015 20:58:33 GMT

Hi, all Thanks for your helps. I end up adding a do loop as below to run the macro 30 times to bootstrap random data.

%Macro doit;

%do i =1 %to 30;

%if i > 30 %then %do;

%analysis('01jan14'd,'31jan14'd, '01-01-2014','01-31-2014')

%end;

%mend;

Re: How to run a macro 60 times and put data into in one table?

XiaoyanZhao — Thu, 23 Apr 2015 21:02:56 GMT

Hi, all

I end up add the macro in the code to execute macro analysis 30 time to bootstrap data for random selected results.

%Macro doit;

%do i =1 %to 30;

%if i > 30 %then %do;

%analysis('01jan14'd,'31jan14'd, '01-01-2014','01-31-2014')

%end;

%mend;

%DOIT

Re: How to run a macro 60 times and put data into in one table?

XiaoyanZhao — Thu, 23 Apr 2015 21:06:14 GMT

Hi, all

I end up add the macro in the code to execute macro analysis 30 time to bootstrap data for random selected results.

%Macro doit;

%do i =1 %to 30;

%if i > 30 %then %do;

%analysis('01jan14'd,'31jan14'd, '01-01-2014','01-31-2014')

%end;

%mend;

%DOIT

Re: How to run a macro 60 times and put data into in one table?

Reeza — Thu, 23 Apr 2015 23:08:22 GMT

You don't use i in the %analysis call, so it executes the same thing over and over...

Re: How to run a macro 60 times and put data into in one table?

art297 — Fri, 24 Apr 2015 00:08:56 GMT

plus the only reason it does anything is because the letter i has a greater value than the characters '30'.

If you are trying to base a decision of whether of not to do something based on the value of &i, you have to specify &i in your %do statement. i.e., %if &i. gt 30 %then %do

However, in this case, you wouldn't do anything since &i will only be greater than 30 as it leaves the loop.

Re: How to run a macro 60 times and put data into in one table?

Ron_MacroMaven — Mon, 27 Apr 2015 20:59:04 GMT

%macro MyMacro(n=1,base=work.output);

%put info: &=n;

*process;

%put remove this line with no ending semicolon

proc append data = &syslast

base = &base;

run;

%mend;

%macro do_this(upperbound=60;

%do i = 1 %to &upperbound;

%put My_macro(n = &i)

%end;

%mend;

%do_this(upperbound = 3)

for loops with dates see this page

http://www.sascommunity.org/wiki/Macro_Loops_with_Dates

Ron Fehd macro loop maven