log using cpsmw, replace
set mem 50m
*by Jean Roth Wed Mar 28 14:57:34 EST 2001
*Please report errors to jroth@nber.org
*Choose time period, 64_88 or 89_92, at the infile statement
*Change output file name/location as desired

*run by opening stata, set mem 50m, 
*use cpsmwYY, where YY is the year of interest, do cpsmw
*choose 64_88 or 89_92

clear
quietly infile using cpsmw64_88.dct


*All the rest are labels

#delimit ;
;
label values hhidnum  P1L;    
label define P1L     
	9           "invalid code"                  
;
label values randomc  P2L;    
label define P2L     
	99999       "bad code"                      
;
label values keyfitz  P3L;    
label define P3L     
	999         "bad code"                      
;
label values nonint   P4L;    
label define P4L     
	99          "bad code"                      
;
label values famdesc  P5L;    
label define P5L     
	1           "primary fam containing no subfams"
	2           "primary fam with 1 or more subfams"
	3           "secondary family"              
	4           "subfamily"                     
	5           "primary individual"            
	6           "sec. indiv., 14+, in a hh"     
	7           "sec. indiv., 14+, in group quarters"
	8           "sec. indiv., under 14, in a hh"
	9           "sec. indiv., under 14, in group quart"
;
label values famposi  P6L;    
label define P6L     
	0           "NIU"                           
;
label values famtypc  P7L;    
label define P7L     
	1           "yes"                           
	2           "no"                            
;
label values kindfam  P8L;    
label define P8L     
        1           "primary family"
        2           "subfamily"
        3           "secondary family"
        4           "primary individual"
        5           "secondary individuals"
;
label values numpfam  P9L;    
label define P9L     
	7           "7+ [1964-67 only]"             
;
label values totfami  P10L;   
label define P10L    
	50000       "$50000 or more [1968-75]"      
;
label values censusg  P11L;   
label define P11L    
	1           "New England"                   
	2           "Middle Atlantic"               
	3           "East North Central"            
	4           "West North Central"            
	5           "South Atlantic"                
	6           "East South Central"            
	7           "West South Central"            
	8           "Mountain"                      
	9           "Pacific"                       
	99          "missing data"                  
;
label values central  P12L;   
label define P12L    
	1           "central city"                  
	2           "balance of SMSA"               
	3           "not in SMSA"                   
	4           "not identifiable [1977+ only]" 
;
label values hhtype   P13L;   
label define P13L    
	1           "household"                     
	2           "group quarter"                 
;
label values hhstatu  P14L;   
label define P14L    
	0           "not in universe (group quarter)"
	1           "primary family"                
	2           "primary individual (alone)"    
	3           "primary indiv. (living with nonrelati"
;
label values numphh   P15L;   
label define P15L    
	99          "secondary individuals"         
;
label values region   P16L;   
label define P16L    
	1           "Northeast"                     
	2           "North Central"                 
	3           "South"                         
	4           "West"                          
	9           "missing [1964]"                
;
label values smsa1    P17L;   
label define P17L    
	0           "not listed below"              
	1           "New York City"                 
	2           "Los Angeles"                   
	3           "Chicago"                       
	4           "Philadelphia"                  
	5           "Detroit"                       
	6           "San Francisco"                 
	7           "Boston"                        
	8           "Pittsburgh"                    
	9           "St. Louis"                     
	10          "Washington, D. C."             
	11          "Cleveland"                     
	12          "Baltimore"                     
	13          "Newark [1968+ only]"           
	14          "Minneapolis - St. Paul"        
	15          "Buffalo"                       
	16          "Houston"                       
	17          "Milwaukee [1968+]"             
	18          "Patterson - Clifton - Passaic [1968+"
	19          "Dallas [1968+]"                
;
label values smsasta  P18L;   
label define P18L    
	1           "SMSA"                          
	2           "NONSMSA"                       
	3           "not identifiable [1977+ only]" 
;
label values state1   P19L;   
label define P19L    
	0           "invalid code [1964-67, 1972]"  
	16          "Connecticut"                   
	19          "ME, MA, NH, RI, VT"            
	21          "New York"                      
	22          "New Jersey"                    
	23          "Pennsylvania"                  
	31          "Ohio"                          
	32          "Indiana"                       
	33          "Illinois"                      
	39          "Michigan, Wisconsin"           
	49          "IA, KS, MN, MO, NE, ND, SD"    
	53          "Washington, D. C."             
	57          "DE, MD, WV, VA"                
	58          "Georgia, NC, SC"               
	59          "Florida"                       
	67          "Kentucky, Tennessee"           
	69          "Alabama, Mississippi"          
	72          "Texas"                         
	79          "Arkansas, Louisiana, Oklahoma" 
	89          "AZ, CO, ID, MT, NV, NM, UT, WY"
	92          "California"                    
	99          "Alaska, Hawaii, Oregon, Washington"
;
label values tothhin  P20L;   
label define P20L    
	50000       "$50000 or more [1968-75]"      
;
label values adc      P21L;   
label define P21L    
	0           "not in universe"               
	1           "yes"                           
	2           "no"                            
	9           "missing data"                  
;
label values age      P22L;   
label define P22L    
	999         "invalid code [1968-69 only]"   
;
label values alimony  P23L;   
label define P23L    
	0           "not in universe"               
	1           "yes"                           
	2           "no"                            
;
label values anyreas  P24L;   
label define P24L    
	0           "not in universe"               
	1           "yes"                           
	2           "no"                            
;
label values cowcurj  P25L;   
label define P25L    
	0           "NIU, NC"                       
	1           "private"                       
	2           "government"                    
	3           "self-employed"                 
	4           "without pay"                   
	5           "never worked or never worked full"
;
label values complet  P26L;   
label define P26L    
	0           "not in universe"               
	1           "yes"                           
	2           "no"                            
	9           "invalid code"                  
;
label values curindu  P27L;   
label define P27L    
	998         "invalid code"                  
	999         "NIU [1968-70]"                 
	0           "NIU [1971+]"                   
;
label values curoccu  P28L;   
label define P28L    
	0           "NIU"                           
;
label values didntwo  P29L;   
label define P29L    
	0           "NIU/did work"                  
	1           "did not work"                  
;
label values employm  P30L;   
label define P30L    
	0           "NIU"                           
	1           "working                employed"
	2           "with job, not at work  employed"
	3           "looking                unemployed"
	4           "house keeping          NILF"   
	5           "at school              NILF"   
	6           "unable                 NILF"   
	7           "other (retired)        NILF"   
;
label values famseco  P31L;   
label define P31L    
	1           "member secondary family no. 1" 
	2           "member secondary family no. 2" 
	3           "member secondary family no. 3" 
	4           "member secondary family no. 4" 
	5           "member secondary family no. 5" 
	6           "member secondary family no. 6" 
	7           "member of primary family or"   
	8           "primary or secondary individual"
;
label values famnum   P32L;   
label define P32L    
	0           "not in sub/secondary family"   
;
label values famreln  P33L;   
label define P33L    
	0           "not in sub/secondary family"   
	1           "head (sub/secondary family)"   
	2           "wife (sub/secondary family)"   
	3           "child (sub/secondary family)"  
	4           "other relative (secondary family)"
;
label values famtyp   P34L;   
label define P34L    
	1           "primary family"                
	2           "secondary individual"          
	3           "secondary family member"       
	4           "subfamily member"              
	5           "primary individual"            
;
label values farmsel  P35L;   
label define P35L    
	50000       "$50000 or more [1968-75]"      
;
label values fptfpar  P36L;   
label define P36L    
	0           "NIU"                           
	1           "full-time (full year worker)"  
	2           "part-time (full year worker)"  
	3           "full-time (part year worker)"  
	4           "part-time (part year worker)"  
	5           "nonworker"                     
	9           "invalid data"                  
;
label values fptwork  P37L;   
label define P37L    
	0           "NIU, not in labor force"       
	1           "employed full time"            
	2           "part-time for economic reasons"
	3           "unemployed full-time"          
	4           "employed part-time"            
	5           "unemployed part-time [1968+ only]"
	6           "with job, not at work [1964-75 only]"
	9           "missing data"                  
;
label values highgra  P38L;   
label define P38L    
	1           "none"                          
	18          "college 5"                     
	19          "college 6+"                    
	0           "NIU (under 14 years)"          
;
label values hourswo  P39L;   
label define P39L    
	0           "NIU"                           
;
label values hhr1     P40L;   
label define P40L    
	1           "head of primary family"        
	2           "wife of primary family head"   
	3           "child, under 18, head of subfamily"
	4           "child, under 18, not in a subfamily"
	5           "child, under 18, ever-married,"
	6           "child, under 18, ever-married,"
	7           "child, under 18, ever-married,"
	8           "18+, never-married, head of subfamil"
	9           "18+, never-married, not in a subfami"
	10          "18+, ever-married, head of a subfami"
	11          "18+, ever-married, wife of a subfami"
	12          "18+, ever-married, not in a subfamil"
	13          "grandchild, under 18, never-married"
	14          "other relative, under 18, head of"
	15          "other relative, under 18, NM, child"
	16          "other relative, under 18, not in"
	17          "other relative, under 18, ever-marri"
	18          "other relative, under 18, ever-marri"
	19          "other relative, under 18, ever-marri"
	20          "other relative, 18+, never-married,"
	21          "other relative, 18+, never-married,"
	22          "other relative, 18+, ever-married,"
	23          "other relative, 18+, ever-married,"
	24          "other relative, 18+, ever-married,"
	25          "in secondary family, head of"  
	26          "in secondary family, wife of"  
	27          "head, child under 18, never-married,"
	28          "under 18, never-married, other"
	29          "under 18, ever-married, other" 
	30          "18+, never-married, secondary family"
	31          "18+, ever-married, other relative"
	32          "primary individual"            
	33          "secondary individual"          
	34          "group quarters, secondary individual"
;
label values hhr2     P41L;   
label define P41L    
	1           "head of household"             
	2           "wife of head of household"     
	3           "child of head, under 18,"      
	4           "child of head, under 18,"      
	5           "child of head, 18+"            
	6           "other relative of head"        
	7           "nonrelative of head"           
	8           "secondary individuals/group quarters"
;
label values hhr3     P42L;   
label define P42L    
	1           "head of family"                
	2           "wife of head"                  
	3           "under 18, single, never married,"
	4           "under 18, ever-married, child" 
	5           "18+, child of family head"     
	6           "grandchild of head [1968+ only]"
	7           "under 18, single, never-married,"
	8           "under 18, ever-married, other relati"
	9           "18+, other relative"           
	10          "primary individual"            
	11          "secondary individual"          
;
label values lwft2pc  P43L;   
label define P43L    
	0           "NIU"                           
	1           "in last 5 years"               
	2           "more than 5 years ago"         
	3           "never worked full time 2+ weeks"
	4           "never worked at all"           
;
label values lwftpay  P44L;   
label define P44L    
	0           "NIU"                           
	1           "within past 12 months"         
	2           "1-2 years ago"                 
	3           "2-3 years ago"                 
	4           "3-4 years ago"                 
	5           "4-5 years ago"                 
	6           "5+ years ago"                  
	7           "never worked"                  
	9           "invalid code"                  
;
label values lfworkl  P45L;   
label define P45L    
	0           "NIU"                           
	1           "yes"                           
	2           "no"                            
	9           "invalid code [1968 only]"      
;
label values lffptwo  P46L;   
label define P46L    
	0           "NIU"                           
	1           "full time"                     
	2           "part time"                     
;
label values lolayed  P47L;   
label define P47L    
	0           "NIU/looking or layed off last year"
	1           "not looking or layed off"      
	9           "invalid code [1968 only]"      
;
label values majacti  P48L;   
label define P48L    
	0           "NIU"                           
	1           "working"                       
	2           "with a job but not at work"    
	3           "looking for work"              
	4           "keeping house"                 
	5           "at school"                     
	6           "unable to work"                
	7           "other/retired"                 
;
label values marital  P49L;   
label define P49L    
	1           "married, spouse present"       
	2           "married, AF spouse absent"     
	3           "married, spouse absent"        
	4           "widowed"                       
	5           "divorced"                      
	6           "separated"                     
	7           "never married (includes under 14)"
;
label values nonfarm  P50L;   
label define P50L    
	50000       "$50000 or more [1968-75]"      
;
label values nftjob   P51L;   
label define P51L    
	0           "NIU"                           
	1           "yes"                           
	2           "no"                            
;
label values nftwork  P52L;   
label define P52L    
	0           "NIU"                           
	1           "yes"                           
	2           "no"                            
;
label values paidtim  P53L;   
label define P53L    
	0           "NIU"                           
	1           "yes"                           
	2           "no"                            
	3           "self-employed"                 
;
label values parents  P54L;   
label define P54L    
	0           "NIU"                           
	1           "both"                          
	2           "mother only"                   
	3           "father only"                   
	4           "neither"                       
;
label values persequ  P55L;   
label define P55L    
	99          "invalid code"                  
;
label values ptincom  P56L;   
label define P56L    
	50000       "50000+ [1968-75 only]"         
;
label values populat  P57L;   
label define P57L    
	1           "civilians 14+ [15+ in 1981]"   
	2           "armed forces"                  
	3           "children [1968+ only]"         
;
label values paamoun  P58L;   
label define P58L    
	0           "NIU/none [1976+]"              
	50000       "50000+ [1968-75 only]"         
;
label values parecip  P59L;   
label define P59L    
	0           "NIU"                           
	1           "yes"                           
	2           "no"                            
	9           "bad data"                      
;
label values race     P60L;   
label define P60L    
	1           "white"                         
	2           "black"                         
	3           "other"                         
;
label values rnawlwk  P61L;   
label define P61L    
	0           "NIU"                           
	1           "already had a job -- U1"       
	2           "temporary illness -- U1"       
	3           "going to school   -- U2"       
	4           "other             -- U2"       
;
label values rnawlyr  P62L;   
label define P62L    
	0           "NIU"                           
	1           "ill"                           
	2           "home [females only]"           
	3           "school"                        
	4           "unable to find work"           
	5           "armed forces [1968-1983]"      
	6           "retired [1968+ only]"          
	7           "other"                         
;
label values relnhhh  P63L;   
label define P63L    
	0           "NIU [1968-76 only]"            
	1           "head with other relatives"     
	2           "primary individual"            
	3           "wife of head"                  
	4           "child of head/other relative of head"
	5           "secondary family member"       
	6           "secondary individual"          
;
label values sex      P64L;   
label define P64L    
	1           "male"                          
	2           "female"                        
;
label values subfam   P65L;   
label define P65L    
	0           "NIU"                           
	1           "member subfamily no. 1"        
	2           "member subfamily no. 2"        
	3           "member subfamily no. 3"        
	4           "member subfamily no. 4"        
	5           "member subfamily no. 5"        
	6           "member subfamily no. 6"        
	9           "invalid code"                  
;
label values unemplo  P66L;   
label define P66L    
	0           "NIU"                           
	1           "yes"                           
	2           "no"                            
;
label values veteran  P67L;   
label define P67L    
	1           "Vietnam Era"                   
	2           "Korean War"                    
	3           "World War II"                  
	4           "World War I"                   
	5           "other service"                 
	6           "nonveteran"                    
	0           "NIU"                           
;
label values perswag  P68L;   
label define P68L    
	0           "NIU/none [1976+]"              
	50000       "50000 or more [1968-75]"       
;
label values wkunemp  P69L;   
label define P69L    
	0           "NIU"                           
;
label values wlly1    P70L;   
label define P70L    
	0           "NIU"                           
;
label values wlly2    P71L;   
label define P71L    
	1           "none (not looking)"            
	2           "1-4 weeks looking"             
	3           "5-14 weeks looking"            
	4           "15-26 weeks looking"           
	5           "27-39 weeks looking"           
	6           "40+ weeks looking"             
	0           "NIU"                           
	9           "invalid code [1968 only]"      
;
label values wllyr1   P72L;   
label define P72L    
	0           "NIU"                           
;
label values wllyr2   P73L;   
label define P73L    
	0           "NIU"                           
	1           "none"                          
	2           "1-4 weeks"                     
	3           "5-10 weeks"                    
	4           "11-14 weeks"                   
	5           "15-26 weeks"                   
	6           "27-39 weeks [1964-67 = 27+ weeks]"
	7           "40+ weeks [1968+ only]"        
	9           "invalid code"                  
;
label values wwly1    P74L;   
label define P74L    
	0           "NIU"                           
;
label values wwly2    P75L;   
label define P75L    
	0           "NIU [1964-1975 only]"          
	1           "0 [1964-1975 only]"            
	2           "1-13 [1964-1975 only]"         
	3           "14-26 [1964-1975 only]"        
	4           "27-39 [1964-1975 only]"        
	5           "40-47 [1964-1975 only]"        
	6           "48-49 [1964-1975 only]"        
	7           "50-52 [1964-1975 only]"        
;
label values whyless  P76L;   
label define P76L    
	0           "NIU"                           
	1           "slack"                         
	2           "material shortage"             
	3           "plant or machine repair"       
	4           "new job started during week"   
	5           "job terminated during week"    
	6           "could find only part time work"
	7           "holiday"                       
	8           "labor dispute"                 
	9           "bad weather"                   
	10          "own illness"                   
	11          "on vacation"                   
	12          "too busy with house, school, etc."
	13          "did not want full time work"   
	14          "full time work week less than 35 hrs"
	15          "other"                         
;
label values whylfwo  P77L;   
label define P77L    
	0           "NIU"                           
	1           "lost job"                      
	2           "quit job"                      
	3           "left school"                   
	4           "wanted temporary work"         
	5           "other"                         
	9           "invalid code"                  
;
label values whynota  P78L;   
label define P78L    
	0           "NIU"                           
	1           "own illness"                   
	2           "on vacation               ESR=2"
	3           "bad weather               ESR=2"
	4           "labor dispute             ESR=2"
	5           "new job begin 30 days     ESR=3"
	6           "temporary layoff          ESR=3"
	7           "indefinite layoff         ESR=3"
	8           "other                     ESR=2"
	9           "invalid code"                  
;
label values povcuto  P79L;   
label define P79L    
	0           "NIU [1976+]"                   
	99999       "NIU [1968-75]"                 
;
label values povlev   P80L;   
label define P80L    
	0           "NIU [1968-75 only]"            
	1           "below poverty cutoff amount"   
	2           "above poverty cutoff amount"   
	9           "missing data"                  
;
label values cowlast  P81L;   
label define P81L    
	0           "NIU"                           
	1           "private wage or salary"        
	2           "government"                    
	3           "self-employed"                 
	4           "w/o pay in family farm or business"
;
label values spanish  P82L;   
label define P82L    
	1           "Mexican"                       
	2           "Puerto Rican"                  
	3           "Cuban"                         
	4           "Central or South American"     
	5           "other Spanish"                 
	6           "other"                         
	7           "don't know"                    
	8           "not available"                 
;
label values stretch  P83L;   
label define P83L    
	0           "NIU"                           
	1           "1 stretch last year"           
	2           "2 stretches last year"         
	3           "3+ stretches last year"        
;
label values wkslabo  P84L;   
label define P84L    
	0           "NIU"                           
	1           "1-13 weeks"                    
	2           "14-26 weeks"                   
	3           "27-39 weeks"                   
	4           "40-47 weeks"                   
	5           "48-49 weeks"                   
	6           "50-52 weeks"                   
	9           "invalid code [1968 only]"      
;
label values famawgt  P85L;   
label define P85L    
	99999       "invalid code"                  
;
label values perawgt  P86L;   
label define P86L    
	99999       "invalid code"                  
;
label values typeain  P87L;   
label define P87L    
	0           "NIU/none [1976+]"              
	50000       "$50000+ [1968-1975]"           
;
label values dividen  P88L;   
label define P88L    
	0           "NIU/none [1976+]"              
;
label values famo18   P89L;   
label define P89L    
	0           "0"                             
	1           "all 18-24, single"             
	2           "some 18-24, single and other"  
	3           "none 18-24, single and other"  
;
label values femalef  P90L;   
label define P90L    
	0           "none"                          
	1           "all in labor force"            
	2           "1+ (not all) in labor force"   
;
label values laborfo  P91L;   
label define P91L    
	0           "1+ employed"                   
	1           "1+ unemployed, none employed"  
	2           "none in labor force"           
	3           "no other members 14+"          
;
label values hhflag   P92L;   
label define P92L    
	1           "hh starts with primary family or indi"
	2           "hh starts with a subfamily family"
	3           "hh starts with a secondary family"
	4           "hh starts with a secondary individual"
	5           "hh starts with a person rec. w/new ID"
	9           "unusable value of family-type"