Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: MORG data aggregation


From   Jimmy Verner <jverner@earthlink.net>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: MORG data aggregation
Date   Fri, 11 Apr 2008 18:02:44 -0500

Yes, the Census' MORG files, which I downloaded from the NBER site.

I think I've got it. If so, this do file would yield Alabama's number of employed persons in January 2006 with individuals weighted by earnwt (which is what NBER calls Census' PWORWGT):

-------------------------------------------------------------------------------
> ----------------------------------------
log: /Applications/Stata/morgjan06alt.log
log type: text
opened on: 11 Apr 2008, 18:01:21

. set mem 1g
(1048576k)

. use "/Applications/Stata/morg06.dta"

. replace earnwt = round(earnwt)
(319197 real changes made)

. quietly sum lfsr94 [fw=earnwt] if lfsr94<=2 & state==63 & intmonth==1

. local emp = r(N)

. display "Employed using earnwt is `emp' "
Employed using earnwt is 2141654

.
end of do-file


Any thoughts or comments?

TIA

Jimmy Verner
Graduate Student
School of Economic, Political & Policy Sciences
University of Texas - Dallas


*
* 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/




© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index