I am trying to figure out how I can count the number of unique values across several variables. Specifically, in my data I have a question that asks "Who helps you with [activity]" for several activities. The response is given as a numeric person identifier. I want to count across all of these questions to see how many unique individuals help take care of a person, across all of the activities. I've been trying to figure out if there's a way to do this with egen and one of the row functions, but can't seem to figure it out.
For example, for the respondent below, I would like the variable to indicate that there are 4 unique helpers (eg, I only want to count 36 once, because that person helps with both bathing and paying bills).
id | year | bathing | dressing | eating | toileting | transfers | walking | medication management | cooking | paying bills |
23348919 | 1998 | 36 | 401 | 101 | 104 | 36 |
Emily
0 Response to Count Number of Unique Values Across Variables
Post a Comment