08-11-2017 03:34 PM
I have a dataset which has many values which are not mutally exclusive (see attached screen shot).
For example, I want to create two custom categories, one that captures "Family Member" and one that captures "Family Physician", however I have a variable called "Family member ; Family Physician" which falls under both. Is there a way to have this value captured in both categories? As an end result, I need to make a bar chart which shows the frequency for all of the possible values:
NOTE: I will need to repeat this for 50+ variables that need to be re-categorized, so I'm hoping there is a way to do it that is not overly time consuming...
Thanks for your insight!