topic Re: Loop inside Macro in SAS Programming

Loop inside Macro

yelena — Wed, 01 Mar 2017 19:57:29 GMT

Dear all,

I am trying to change the format from character to numeric of a list of variables in my dataset. I've written the code but it seems that it applies only to the last variable. So I cannot see all new numeric variables in my dataset. Can anyone help me? The code is attached.

%macro numeric(var);
data mydata.fhsim_n;
set mydata.fhsim;
&var._n=input(&var ,8.);
run;
%mend numeric;
%numeric(Account_No); run;
%numeric(Acct_Status); run;

Re: Loop inside Macro

art297 — Wed, 01 Mar 2017 20:01:52 GMT

You're rewriting the new file each time you run the macro.

Art, CEO, AnalystFinder.com

Re: Loop inside Macro

yelena — Wed, 01 Mar 2017 20:04:19 GMT

What should I then do to keep all variables in?

Re: Loop inside Macro

art297 — Wed, 01 Mar 2017 20:09:25 GMT

I wouldn't use a macro for it but, since you already wrote it, just make a copy of your original file and then change your macro to work on that file.

/* first run a data step like*/

data mydata.fhsim_n;
  set mydata.fhsim;
run;

/*then change your macro to*/
%macro numeric(var);
  data mydata.fhsim_n;
    set mydata.fhsim_n;
    &var._n=input(&var ,8.);
  run;
%mend numeric;

%numeric(Account_No); run;
%numeric(Acct_Status); run;

Art, CEO, AnalystFinder.com

Re: Loop inside Macro

yelena — Wed, 01 Mar 2017 20:13:19 GMT

Thank you very much! Let me try!