Re: Aggregating household level data [message #10400 is a reply to message #10394] |
Mon, 25 July 2016 17:59 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
Reduced-For(u)m
Messages: 292 Registered: March 2013
|
Senior Member |
|
|
It looks to me like you are telling Stata to treat your categorical variable as a continuous variable. If you want to keep each individual occupation, you'll need to create a separate dummy variable for each occupation, and then when you collapse those you will have a proportion of the population with that occupation in that cluster. If there are too many different groups, you'll probably need to combine them in some way.
But right now I think you are just getting a meaningless number because you are treating the variable value of, say, "4" as the number 4 and not as "occupation group 4." So those numbers below are meaningless.
|
|
|