I am a first-time Stata user, and have a relatively basic question. Is
there some way to calculate the weighted mean and median of a variable
without using the "collapse" command? As part of a program, I need to
calculate the weighted mean and median to perform other operations on the
dataset, but using "collapse" clears the original variables from the
workspace. I tried "egen" but that doesn't allow for weighted means.
Here are the specifics: I have household income data for US 1994, from
which I want to calculate the median income. Then I want to disaggregate
households by state and calculate the regional medians. Finally, I want to
calculate the ratio of the regional medians to the national median. Using
"collapse" to calculate the national median removes the original
observations from the working space.
Thanks,
Nirmala
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
