Loop inside Macro

[yelena]

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;

[art297]

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

Art, CEO, AnalystFinder.com

[yelena]

What should I then do to keep all variables in?

[art297 · Accepted solution]

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

[yelena]

Thank you very much! Let me try!