Re: st: MORG data aggregation

[Jimmy Verner <jverner@earthlink.net>]

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/