I have a variable with categorical observation. eg id eth 1 1 2 1,2,3 3 2,5 4 4 and so on..... The data is present in a csv format file. When i import the data, SAS does not recognize the comma between the observations. My proc freq appears something like this: eth frequency 1 1258 2 456 13 445 14 454 16 23 Instead of 13, 14, 16, I want sas to recognize they are separate option like 1 and 3, 1 and 4. My goal is to count the total 1s,2s,3s and so on. But here instead of 1and 3, the observation appears as 13.
... View more