DATA Step, Macro, Functions and more

Recoding multiple variables at the same time

Accepted Solution Solved
Reply
New User
Posts: 1
Accepted Solution

Recoding multiple variables at the same time

Hi,

 

I would like to recode a bunch of variables at the same time. For e.g. I have the following variables:

 

1) A

2) B

3) C

4) D

 

They all take values from 1 through 9. I want to recode the values for all these variables in the same manner.

E.g. if A = 1 then A = 10. The same rule applies to all the variables (A-D). Is there a way to do this using a macro or a loop? I don't want to give if-then commands individually for each of the 4 variables and am looking for a more efficient way to do this. 

 

Thanks for your help!


Accepted Solutions
Solution
‎11-24-2016 09:25 AM
Super User
Posts: 5,509

Re: Recoding multiple variables at the same time

SAS contains a standard tool for processing a group of variables in the same way.  Arrays do that:

 

data want;

set have;

array vars {4} a b c d;

do _n_=1 to 4;

   if vars{_n_}=1 then vars{_n_}=10;

end;

run;

 

You'll need to type all your IF/THEN statements once.  Then the DO loop changes one variable at a time, applying all the logic between DO and END.

View solution in original post


All Replies
Solution
‎11-24-2016 09:25 AM
Super User
Posts: 5,509

Re: Recoding multiple variables at the same time

SAS contains a standard tool for processing a group of variables in the same way.  Arrays do that:

 

data want;

set have;

array vars {4} a b c d;

do _n_=1 to 4;

   if vars{_n_}=1 then vars{_n_}=10;

end;

run;

 

You'll need to type all your IF/THEN statements once.  Then the DO loop changes one variable at a time, applying all the logic between DO and END.

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 559 views
  • 1 like
  • 2 in conversation