Hello,
I have CPS monthly data 2015-present. I want to calculate unemployment rate. I am using empstat and labforce variables from the CPS. I am also using wtfinl as the weights for the data.
My question is how to calculate the weighted unemployment rate using this data? I was able to calculate the unweighted rate using
gen unemployed = (empstat==21)+(empstat==22)
gen lf = labforce==2
gen unemp_rate = (unemployed==1)/(lf==1)
When I multiplied unemployment_rate by the wtfinl variable, I got very large unemployment rate. I do not know what am I doing wrong? How to weight the unemployment rate?
Also, a very stupid question, my data is individual level. How can I aggregate the weighted unemployment rate into a table of (year - month - weighted unemployment rate)? I mean I do not know how to report the weighted unemployment rate for each month of my period (2015-present).
Thanks
Related Posts with How to weight data using CPS weights in STATA?
Convert date and time to Stata formatHi all, I would like to convert the following date and time format into Stata format, so that I can…
question on line chart outputHello, I created a twoway line chart but the output is too small and I'm not sure how to make it la…
how many waves at least needed to run system GMMDear all, I'm estimating system gmm on a panel of 249 individuals across three waves. I wanted to l…
Creating dummy variable based on percentilesHi Everyone, I have a variable G-Index with the following distribution: Governance | Index | (Gom…
Replace missing values in panel dataset by the mean, by pasting up, by pasting downHello, I have the following dataset: clear input year id value 1990 1 . 1991 1 . 1992 1 4 1993 1 . …
Subscribe to:
Post Comments (Atom)
0 Response to How to weight data using CPS weights in STATA?
Post a Comment