Hi All, I want to change values of my columns (Q1-5) where there is '1' with different values in each column i.e for Q1, 1 will be remain same as 1 but in col 2, for the value '1' will replace by 2 similarly col3, col 4, col 5 for the value of 1 will value be replaced by 3, 4, 5 as in "data want_1". Finally i want the dataset from wider to longer n(as in Data want_2). Probably using ARRAY:
Really appreciate your help! Akter
data main; Input ID Q1-Q5; Datalines; 1 1 0 0 0 0 2 0 1 0 0 1 3 0 0 0 1 1 4 1 1 0 0 0 5 0 0 1 0 0 ; run;
Data want_1; ID Q1 Q2 Q3 Q4 Q5 1 1 0 0 0 0 2 0 2 0 0 5 3 0 0 0 4 5 4 1 2 0 0 0 5 0 0 3 0 0
data want_2: Id New_Var 1 1 2 2 2 5 3 4 3 5 4 1 4 2 5 3
... View more