count cases text

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Fri Nov 28, 2014 4:47 pm

count cases text

Postby johannesantonius » Fri Nov 28, 2014 4:54 pm


I hope you guys can help me out, this should be easy...

I imported the dataset from exel, and now some of the answers that have multiple choices are all packed in one variable. For example

What is your occupation? (more options possible)
- A
- B
- C
- Other:

So now I my dataset the answers are separated by comma's, all in one column, like this:

resp 1: A
resp 2: A, C
resp 3: C
resp 4: B, C, Other: Z

how can I count the number of A's in all responses?
how can I classify all 'Other' as one category?


Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: count cases text

Postby GerineL » Mon Dec 01, 2014 2:02 pm

super easy fix: can't you just go back to excel and get each value in a separate variable? that would be very easy.

if that doesn't work, look into the "index" function.

Who is online

Users browsing this forum: letiziamdr and 2 guests