Hey all! I've got some survey data that came out of Qualtrics where the "Check all that apply" options were all put in the same field with commas separating the options. For example, We had a question asking what topics people were most interested in (select up to 5) and the results came back like this: Education,Technology Health care,Human services Health care,Human services,Justice and law ,Public safety and emergency ,Workforce and the economy Education,Housing,Human services,Justice and law ,Technology Agriculture,Education,Environment and natural resources,Health care,Workforce and the economy Health care,Human services,Technology,Workforce and the economy Environment and natural resources,Housing,Justice and law ,Transportation and infrastructure,Workforce and the economy Education,Environment and natural resources,Health care,Justice and law ,Technology Finance, accounting and procurement,Justice and law ,Tax and fiscal policy,Technology,Workforce and the economy Education,Environment and natural resources,Housing,Public safety and emergency ,Transportation and infrastructure Agriculture,Energy,Environment and natural resources,Transportation and infrastructure,Workforce and the economy Energy,Health care,Human services,Public safety and emergency ,Workforce and the economy Health care,Justice and law ,Tax and fiscal policy,Technology,Workforce and the economy Environment and natural resources Environment and natural resources,Health care,Justice and law ,Transportation and infrastructure,Technology Clearly I'd like to split all this data up so that I can get summary counts of each topic. Any thoughts on how I can do this quickly and easily? I'm mostly stumped. I don't even mind if I have a separate data set with one column where each row is a single response. I'm totally cool with that. Just don't know how to get there... I found one option that sort of looks like what I want, if only I could get it to work for the entire dataset... If you check out the SAS Documentation for the SCAN function (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm) under Example #2 there's a piece where it uses a do loop to split apart each word in a string. However, when I tried this with my dataset (see sample code below) it only gave me the data for the first observation. It's late in the day and I can't figure this one out. Thoughts? data split; set results;
keep word;
do until(word=' ');
count+1;
word = scan(Q6, count);
output;
end;
run;
... View more