topic Problem in passing parm to macro need help in SAS Programming

Problem in passing parm to macro need help

Dennis_Lam — Thu, 02 Feb 2012 16:31:19 GMT

Hi, I have problem on passing parm to a macro wish someone can give me a hand. Following is the script that I have. I am trying to pass parm to the macro using a do loop but it was not successful. Can anyone give me some advice. thanks.

DATA rev_data;
FORMAT rep_month $7. ;
INPUT @1 rep_month $7.;
CARDS;
2012-01
2012-02
2012-03
;

data rev_data; set rev_data;
by rep_month;
   if first.rep_month then do;
     cnt = left(put(_n_,6.));
    call symput('mth'||cnt, rep_month);
    call symput('mthcount', cnt);
    end;
run;
%put _user_;

%macro a(m_mth, m_mthcount);

%put month = &m_mth. count = &m_mthcount.;
%mend;
%a(&mth1, &mthcount);
data _d_;
do i = 1 to &mthcount;
   runmth = '&mth'||i;
   %a(&mth||i,i);
end;
   run;

Problem in passing parm to macro need help

Haikuo — Thu, 02 Feb 2012 16:42:23 GMT

For the last part of your code, I have modified it to macro, hopefully it is what you want:

%macro test;

data _d_;

%do i = 1 %to &mthcount;

runmth = "&&mth&i";

output;

%a(&&mth&i,&i);

%end;

run;

%mend;

%test

proc print;run;

Kindly Regards,

Haikuo

Problem in passing parm to macro need help

Dennis_Lam — Thu, 02 Feb 2012 18:01:45 GMT

Hi HaiKuo, thank you for your help.. Your solution work.. thanks a lot...