Hi there: I am working w/ a .csv file exported from a Qualtrics survey. One of my questions had a checklist option, and the output from Qualtrics when I run a proc freq gives a table with all possible combinations of answers. For instance: 12 people said option 1 and option 2, 11 people said just option 1, 110 people said option 1, 2 and 3, 40 people said options 1 and 3, 15 people said just option 3 etc. My goal is to get the proc freq to create a table that provides each possible answer separately, as in: how many people selected option 1, how many people selected option 2, how many people selected option 3. So that I can see each variables response separately. Below is what I have been told to code (these are character variables) - it doesn't generate any errors, but it produces the same proc freq table with all the possible combinations tallied. data sasintro.data_clean; set allpreg; if qx11 ^=" " then do; Heavy_workload="0"; Concern_regarding_career="0"; Discouraged_by_partner="0"; Discouraged_by_peers="0"; Discouraged_by_supervisor="0"; Other_please_specify="0"; end; if index (qx11,"Heavy") then Heavy_workload="1"; if index (qx11,"Concern") then Concern_regarding_career="1"; if index (qx11,"partner") then Discouraged_by_partner="1"; if index (qx11,"peers") then Discouraged_by_peers="1"; if index (qx11,"supervisor") then Discouraged_by_supervisor="1"; if index (qx11,"Other") then Other_please_specify="1"; run; Any ideas what my issue is? Thanks 🙂
... View more