DATA Step, Macro, Functions and more

how to reduce repetion of proc

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

how to reduce repetion of proc

I need to call a proc with different argument. In my code below, I have to change

1)value of p in each model statement

2)numeric value in the title.

It seems I cant do it in do loop. Should I use macro or is there a better way of reducing this repetitive code.

thank you

kashili

title "arch=1";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2  noint garch=(p=1);

run;

title "arch=2";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2    noint garch=(p=2);

run;

title "arch=3";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2    noint garch=(p=3);

run;

title "arch=4";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2    noint garch=(p=4);

run;

title "arch=5";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2    noint garch=(p=5);

run;

title "arch=6";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2    noint garch=(p=6);

run;


Accepted Solutions
Solution
‎03-04-2013 06:34 PM
Occasional Contributor
Posts: 17

Re: how to reduce repetion of proc


Hi,

Below macro will avoid reptitive use of proc but i don't know whether this the better way of reducing.

%macro proc_rep(p=);

%do i=1 %to &p;

title "arch=&i";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2  noint garch=(p=&i);

run;

%end;

%mend;

%proc_rep(p=6);

Regards

Sylas.J

View solution in original post


All Replies
Solution
‎03-04-2013 06:34 PM
Occasional Contributor
Posts: 17

Re: how to reduce repetion of proc


Hi,

Below macro will avoid reptitive use of proc but i don't know whether this the better way of reducing.

%macro proc_rep(p=);

%do i=1 %to &p;

title "arch=&i";

proc autoreg data=Ethylene maxit=2000;

model ret = /  nlags=2  noint garch=(p=&i);

run;

%end;

%mend;

%proc_rep(p=6);

Regards

Sylas.J

Valued Guide
Posts: 634

Re: how to reduce repetion of proc

The AUTOREG procedure supports multiple MODEL statements.  Each can have its own label.  This allows a single read of the data.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 197 views
  • 0 likes
  • 3 in conversation