Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Dimitriy V. Masterov" <dvmaster@gmail.com> |

To |
Statalist <statalist@hsphsun2.harvard.edu> |

Subject |
st: collapse with multiple sets of weights |

Date |
Thu, 12 Apr 2012 11:05:34 -0400 |

I am trying to aggregate some spatial data. Here's a simplified version of my problem. I have two variables, average wage and population, in three areas. I would like to sum the population, but calculate a weighted mean of the average wage. Is there a way to do this in one step using collapse? For example, the following code gets the mean right, but the population "wrong": set obs 3; input pop avgwage; 10 20; 20 10; 40 30; egen double w=total(pop); replace w=pop/w; collapse (sum) pop (mean) avgwage [w=w]; I would like to see 70, not 90. Is there a collapse-like command where I apply the weight only to the mean calculation? I suppose I could do this in two collapse steps, but that seems clunky. DVM * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: collapse with multiple sets of weights***From:*Scott Merryman <scott.merryman@gmail.com>

- Prev by Date:
**Re: st: no difference between results obtained from -margins- and -margins, atmeans-** - Next by Date:
**Re: st: import excel** - Previous by thread:
**st: no difference between results obtained from -margins- and -margins, atmeans-** - Next by thread:
**Re: st: collapse with multiple sets of weights** - Index(es):