Hi All, Now the issue is: I have a series variable: V1, V2, ... Vn. Each Variable has two value to classify the group: V1_a, V1_b. According to the variable value, Group information is assigned to another variable G1, G2, ... Gn. For example: (V1 has value 1 to 10), (V1_a=3, V1_b=7), then if .Z<V1<=V1_a then G1=1, else if V1_a<V1<=V1_b then G1=2; else G1=3; What I have: Variable V1, V2, ... Vn. and G1, G2, ... Gn. Macro variables: V1_a, V1_b, V2_a, V2_b, ... Vn_a, Vn_b. What I want to solve: I want to use a loop to automatically generate macro variable NAME - V1_a, V1_b, V2_a, V2_b, ... Vn_a, Vn_b, according to the Variable name: V1, V2, ... Vn. In data step , how do I dynamic to generate macro variable name to generate the group variable? DATA NEW; SET OLD; ARRAY VAR_O{2, 50} V1, V2, ... V50 G1, G2, ... G50; DO k = 1 TO 50; /*My problem to solve: Generate the macro name Vk_a, Vk_b*/ IF .Z < VAR_O{1, k} <= Vk_a THEN VAR{2, k}=1; ELSE IF Vk_a < VAR_O{1, k} <= Vk_b THEN VAR{2, k}=2; ELSE VAR{2, k}=3; END; RUN; Any suggestions is appreciated. Thanks, Abdu.
... View more