-----------------------------------------------------------------------------------------------------------------------------------
       log:  /hdir/0/ebenstei/data/cps/morg/logs/morg_pool.log
  log type:  text
 opened on:  25 Jul 2007, 13:23:56

. /*==============================================================
>  Program: morg_data.do
>  Author:  Avi Ebenstein
>  Created: June 2007
>  Purpose: Pool together annual CPS MORG files and
>           keep only those employed or unemployed
>           (excluding those not in labor force),
>           age 16-64. I also create a consistent
>           variable for years of education, and assign
>           the workers consistent occupation and
>           industry codes. The occupation is used to gather
>           info on the skill mix, and one can map SIC to
>           the industry code.
>           I also adjust the wages for inflation using the
>           CPI. The resulting data set is saved as morg_pool.dta,
>           and the manufacturing subset is morg_man.dta.
> ==============================================================*/
> 
> *****************;
. * Unzip the data ;
. *****************;
. /*
> gen a=1;
> set obs 1;
> forvalues year=1979/2002{;
> !                     unzip ~/data/cps/morg/datafiles/cepr_org_`year'_dta.zip;                      
>                     };
> 
> *******************************************************************************;
> * Assign occupation, industry, and skills of workers consistently across years ;
> *******************************************************************************;
> 
> forvalues year=1979/2002{;
> 
>                             use ~/data/cps/morg/datafiles/cepr_org_`year'.dta, clear;
>                             tab year;
> 
>                             if `year'>=1979 & `year'<=1982{;
>                                                        sort occ70;
>                                                        merge occ70 using ~/research/outsourcing/autor/dot91-70;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                        
>                                                        sort ind70;
>                                                        merge ind70 using ~/research/outsourcing/autor/ind70;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                      };
> 
>                             if `year'>=1983 & `year'<=1991{;
>                                                        sort occ80;
>                                                        merge occ80 using ~/research/outsourcing/autor/occ80;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
> 
>                                                        sort occ8090;
>                                                        merge occ8090 using ~/research/outsourcing/autor/dot91-8090;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                        
>                                                        sort ind80;
>                                                        merge ind80 using ~/research/outsourcing/autor/ind80;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                      };
> 
>                             if `year'>=1992 & `year'<=2002{;
>                                                        capture rename occ80 occ90;
>                                                        sort occ90;
>                                                        merge occ90 using ~/research/outsourcing/autor/occ90;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                                      
>                                                        sort occ8090;
>                                                        merge occ8090 using ~/research/outsourcing/autor/dot91-8090;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                                      
>                                                        capture rename ind80 ind90;
>                                                        sort ind90;
>                                                        merge ind90 using ~/research/outsourcing/autor/ind90;
>                                                        tab _merge;
>                                                        keep if _merge==1|_merge==3;
>                                                        drop _merge;
>                                                      };
>                                                       save ~/data/cps/morg/datafiles/morg`year', replace;
>                           };
> */
> 
> *****************************;
. *  Bring in individual years ;
. *****************************;
. use ~/data/cps/morg/datafiles/morg1979;
(CEPR ORG Extract, Version 1.1, 1979)

. for num 1980/2002: append using ~/data/cps/morg/datafiles/morgX;

->  append using ~/data/cps/morg/datafiles/morg1980
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind70 already defined)
(label docc70 already defined)
(label occ70 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1981
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind70 already defined)
(label docc70 already defined)
(label occ70 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1982
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind70 already defined)
(label docc70 already defined)
(label occ70 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1983
ind80 was byte now int
occ80 was byte now int
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1984
fnlwgt was int now float
orgwgt was long now double
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1985
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1986
cmsarank was byte now int
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1987
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1988
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1989
msafips was byte now int
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1990
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1991
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1983 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1992
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1993
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1992 already defined)
(label reason79 already defined)
(label absent79 already defined)
(label why3579 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1994
penatvty was byte now int
pemntvty was byte now int
pefntvty was byte now int
pehruslt was byte now int
imphrs was byte now float
uhoursi was byte now float
wkotc was byte now float
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1992 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1995
hhid was str12 now str15
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label usyr1994 already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1996
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1997
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label usyr1996 already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1998
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg1999
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg2000
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg2001
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

->  append using ~/data/cps/morg/datafiles/morg2002
(label link already defined)
(label wbho already defined)
(label prcitshp already defined)
(label arrived already defined)
(label cob already defined)
(label fr84 already defined)
(label fr94 already defined)
(label fr already defined)
(label lfstat already defined)
(label state already defined)
(label educ already defined)
(label ind_nber already defined)
(label ind80 already defined)
(label docc80 already defined)
(label occ1995 already defined)
(label reason94 already defined)
(label absent94 already defined)
(label why3594 already defined)
(label prhrusl already defined)

. *save ~/data/cps/morg/datafiles/temp, replace;
. *use ~/data/cps/morg/datafiles/temp,clear;
. *********************;
. * Education in years ;
. *********************;
. gen yrsed=0;

. replace yrsed=10 if educ==1;
(1854075 real changes made)

. replace yrsed=12 if educc==2;
educc not found
r(111);

end of do-file
r(111);

. ex,clear