Hello, I have a series of 10 Likert scale (1-3) variables that need to be recategorized using the same criteria. The variables are as follows: a1_c_q1 - a1_c_q5, where 'a1' is administrator 1, 'c' is cognitive test, and 'q' represents the questionnaire number (1 though 5). a2_c_q1 - a2_c_q5, where 'a2' is administrator 2, 'c ' is cognitive test, and 'q' represents the questionnaire number (1 through 5). For each of the 10 variables, I am looking to create a new recategorized variable where 1=3 and 3=1. Is there a way to use an array or loop in the code so the same lines do not need to be repeated 10 times? DATA new1;
SET new;
a1_c_q1_new=a1_c_q1;
IF a1_c_q1=3 THEN a1_c_q1_new=1;
ELSE IF a1_c_q1=3 THEN a1_c_q1_new=1;
RUN;
... View more