Dear SAS community, I need your help. Image I have the following column with about 120 different observations Column1 A B C A D E F B C I want to create a numeric variable (Column2) based on the Column1 like this Column1 Column2 A 1 B 2 C 3 A 1 D 4 E 5 F 6 B 2 C 3 How can I create the Column2 based on the values from the Column1? I want to have the same number for the same values from the character variable Column1, i.e. A gets the number 1, B the number 2, C the number 3 etc. Many thanks and best regards
... View more