DATA Step, Macro, Functions and more

Problem in passing parm to macro need help

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Problem in passing parm to macro need help

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;


Accepted Solutions
Solution
‎02-02-2012 11:42 AM
Respected Advisor
Posts: 3,156

Problem in passing parm to macro need help

Posted in reply to Dennis_Lam

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

View solution in original post


All Replies
Solution
‎02-02-2012 11:42 AM
Respected Advisor
Posts: 3,156

Problem in passing parm to macro need help

Posted in reply to Dennis_Lam

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

New Contributor
Posts: 3

Problem in passing parm to macro need help

Posted in reply to Dennis_Lam

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

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 136 views
  • 3 likes
  • 2 in conversation