Creating the dummy variables is what I had in mind... I've adopted your code but it does not seem to be capturing the responses and creating variables appropriately... This is my actual code with all the possible responses a respondent can select: data test; set site3.parent; ConnectResources = index(Q20_HSS_Helpful, "Connecting me with resources (e.g., housing assistance, diapers, employment, etc.)")>0; HelpFeed = index(Q20_HSS_Helpful, "Helping me with feeding issues (e.g., breastfeeding support)")>0; ChildDevelop = index(Q20_HSS_Helpful, "Providing me with information about my childs development")>0 ; ChildCareInfo = index(Q20_HSS_Helpful, "Providing me with information about how to care for my child")>0; HelpChildConcerns = index(Q20_HSS_Helpful, "Helping me with concerns I have about my child")>0; HelpSelfFamilyConcerns = index(Q20_HSS_Helpful, "Helping me with concerns I have about myself or my family")>0; AvailableBtwnVisits = index(Q20_HSS_Helpful, "Being available to me in between my childs doctor visits")>0; run; Here is the resulting columns in the table:
... View more