Dear Stata users,
I have a panel data set with 14 string variables each of which indicates whether this type of service is provided (one variable per service), and if it is, by what means.
These variables can take values "NP", "Comb", "Other gov", "Own gov", "Private", "RDC".
I would like to create a count variable "total" indicating the number of services provided for each observations. This variable would most likely count the number of "NP"s in all 14 variable for a given id-year, and subtract that from 14 (because 14 is the maximum number of services provided, subtracting the number of those not provided would give me what I need). I have not been able to find any way of doing this in Stata, so I wanted to ask for advice. Please let me know if this information is insufficient or unclear.
Thank you!
Related Posts with Generate a count variable capturing # of times a value occurs in categorical variables
Normalized cross-correlation with time-shiftDear all, I would like to perform normalized cross-correlation with time-shift to explore relations…
Assign variables labels based on values of other variablesDear Statalist, I am working on a dataset as below: Code: * Example generated by -dataex-. To ins…
Checking for Missing Head of Houshold within a householdHello, I have a data set on household survey where the household size, member of the household numbe…
Assign string variable to all in groupI would like to assign a string variable to all in a group. I want to be able to assign "IA" if any …
Using Ghostscript to Increase Resolution of GraphHello all, I am seeking to increase the resolution of a graph to 300 dpi for publication. While I'v…
Subscribe to:
Post Comments (Atom)
0 Response to Generate a count variable capturing # of times a value occurs in categorical variables
Post a Comment