Forgot to say --
then drop the extra observations (last line below)!
... note the extra step for CPS files after infiling is to -replace-
household and family record variables with something like:
unab x: hrecord-frecord
loc x: subinstr local x "frecord" "", all
loc x: subinstr local x "hrecord" "", all
qui foreach v of local x {
replace `v'=`v'[_n-1] if hrecord>1
}
unab x: frecord-precord
loc x: subinstr local x "precord" "", all
loc x: subinstr local x "frecord" "", all
qui foreach v of local x {
replace `v'=`v'[_n-1] if hrecord==3
}
keep if hrecord==3
*
* 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/
