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
Directly modifying part of a date variableDear Stata users, I have a date variable formatted using %tmCCYYMon. However, I have identified a s…
How to calculate the same propensity score within an individual in panel data ?I am trying to estimate the propensity score to balance the difference between the treated and the c…
Interpreting probit marginal effectsI have a question about how to interpret the marginal effects in a probit model that I hope someone …
Forest plot to present interaction in a cross sectional studyHello, I am trying to use ipdover command and I followed the advices that I found in the website, b…
Country and Time Fixed EffectsHi! I am doing a fixed effects regression on the impact of trade (TGDP) on inequality (Gini). My pa…
Subscribe to:
Post Comments (Atom)
0 Response to Generate a count variable capturing # of times a value occurs in categorical variables
Post a Comment