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

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

From |
Daniel Feenberg <feenberg@nber.org> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: pweight for households |

Date |
Sat, 14 May 2011 08:15:02 -0400 (EDT) |

On Fri, 13 May 2011, Constance Kelly wrote:

I'm using the Current Population Survey (March Supplement) for a project, andI need to derive an estimate of the number of households in the population.There is a household population weight built into the data. The problem isthat the data is structured by person, with individual household identifiernumbers, i.e.:Person I.D. | Household I.D. 1 | 1 2 | 1 3 | 1 4 | 2 5 | 3 6 | 3 etc.I know that if I reshape the data from long to wide, I can get the populationhousehold estimate, but I'm trying to figure out if there is a simper way toderive this value.Any insight would be appreciated.

need to know that hhdrel==1 for the household head, so all you need to do is get the sum of the weights of those records. First, she might try count if hhdrel==1 [pweight=weight] but -count- doesn't take weights. Then try: summarize if hhdrel==1 [pweight=weight] won't work because summarize doesn't take pweights summarize if hhdrel==1 [aweight=weight] won't work because -summarize- doesn't offer a weighted count. Everything else is weighted, but not the count. summarize weight if hhdrel==1

That isn't desirable. What about -tabulate-? tabulate hhdrel [pw=w] if hhdrel==1 won't work because tabulate doesn't take pweights. tabulate hhdrel [aw=w] if hhdrel==1 gives the wrong answer. tabulate hhdrel [iw=w] if hhdrel==1

table hhdrel [pw=w] if hhdrel==1 which is documented or even egen sum=sum(weight) if hhdrel==1 summarize sum or -table-, -collapse-, and possibly 7 other ways, but the lack of pweights on many of the commands is a mystery to me - I never have any other kind. Daniel Feenberg * * 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: pweight for households***From:*Nick Cox <njcoxstata@gmail.com>

**References**:**st: pweight for households***From:*Constance Kelly <cckelly@email.wm.edu>

- Prev by Date:
**st: RE: Question about Hausman test results: V_b - V_B not positive definite** - Next by Date:
**Re: st: -svy- commands with a pps sample vs. a simple random sample** - Previous by thread:
**st: pweight for households** - Next by thread:
**Re: st: pweight for households** - Index(es):