Hi all, I have a dataset that contains 9 variables for ethnic group, all binary where 1 means respondent belongs to that ethnic group and 0 means respondent doesn't. so I have ethnic1 ethnic2 to ethnic9, each has value 1 or 0. I want to create a single ethnic value where each respondent has a value from 1-9 indicating which ethnic group they belong to. I have done a lot of reading around and tried a lot of things from arrays to catx but I cannot seem to make things work. can anyone help? I am using SAS university edition, this is the last thing I tried (new to sas so I find this so confusing) data Bios.prjtnew; set Bios.prjtc; ethnic = catx(ethnic_group___1, best8.),put(ethnic_group___2, best8.), put(ethnic_group___3, best8.), put(ethnic_group___4, best8.),put(ethnic_group___5, best8.), put(ethnic_group___6, best8.), put(ethnic_group___7, best8.),put(ethnic_group___8, best8.) and put (ethnic_group___9, best8.)); run; I am hoping to have a single ethnic variable where the value will be say 6 if the respondent belongs to ethnic group 6
... View more