set more 1 /* File: cepr_org_demog.do Date: Nov 14, 2005, CEPR ORG Version 1.0 Desc: Creates consistent demographic variables for CEPR consistent extract of CPS ORG Note: See copyright notice at end of program. */ /* Determine data year */ local year=year in 1 /* Age */ lab var age "Age" notes age: CPS: a-age, peage /* Gender */ gen byte female=0 if sex==1 replace female=1 if sex==2 lab var female "Female" notes female: CPS: derived from a-sex, pesex /* Race and ethnicity */ if 1979<=`year' & `year'<=1988 { gen byte wbho=1 if race==1 replace wbho=2 if race==2 replace wbho=4 if race==3 replace wbho=3 if 1<=ethnic & ethnic<=7 } if 1989<=`year' & `year'<=1995 { gen byte wbho=1 if race==1 replace wbho=2 if race==2 replace wbho=4 if 3<=race & race<=5 replace wbho=3 if 1<=ethnic & ethnic<=7 } if 1996<=`year' { gen byte wbho=1 if race==1 replace wbho=2 if race==2 replace wbho=4 if 3<=race & race<=5 replace wbho=3 if 1<=ethnic & ethnic<=7 } lab var wbho "Race" #delimit ; lab define wbho 1 "White" 2 "Black" 3 "Hispanic" 4 "Other" ; #delimit cr lab val wbho wbho notes wbho: Racial and ethnic categories are mutually exclusive notes wbho: CPS: derived from a-race, perace, a-reorgn, prorigin /* Race category 2003- */ gen byte wbhom=. /* Foreign-born status (from 1994 only) */ if `year'<1994 { gen byte forborn=. gen byte citizen=. gen byte prcitshp=. gen penatvty=. gen pemntvty=. gen pefntvty=. gen prinusyr=. gen byte arrived=. } if 1994<=`year' & `year'<=2002 { gen byte forborn=0 if prcitshp~=. replace forborn=1 if prcitshp==4 | prcitshp==5 gen byte citizen=0 if prcitshp~=. replace citizen=1 if 1<=prcitshp & prcitshp<=4 rename peinusyr prinusyr gen byte arrived=prinusyr replace arrived=. if prinusyr==0 replace arrived=13 if 14<=prinusyr & prinusyr<=17 } lab var forborn "Foreign born" notes forborn: CPS: derived from prcitshp lab var citizen "US citizen" notes citizen: CPS: derived from prcitshp lab var prcitshp "Citizenship status" notes prcitshp: CPS: prcitshp #delimit ; lab define prcitshp 1 "Born in US" 2 "Born in PR / OA" 3 "For. born, US parents" 4 "For. born, naturalized" 5 "For. born" ; #delimit cr lab val prcitshp prcitshp lab var arrived "Year entered US" #delimit ; lab define arrived 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-" ; #delimit cr lab val arrived arrived notes arrived: See "prinusyr" for year-specific variable notes arrived: CPS: prinusyr /* due to inconsistencies over time in coding structure of prinusyr, the last value of "arrived" (==13) refers to 1992 or later, with no finer, consistent breakdown; the dataset retains the inconsistently coded prinusyr variable for more detailed analysis */ if 1994<=`year' & `year'<=1995 { #delimit ; lab define usyr1994 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-95" ; #delimit cr lab val prinusyr usyr1994 } if 1996<=`year' & `year'<=1997 { #delimit ; lab define usyr1996 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-93" 14 "1994-97" ; #delimit cr lab val prinusyr usyr1996 } if `year'==1998 { #delimit ; lab define usyr1998 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-93" 14 "1994-95" 15 "1996-98" ; #delimit cr lab val prinusyr usyr1998 } if `year'==1999 { #delimit ; lab define usyr1999 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-93" 14 "1994-95" 15 "1996-99" ; #delimit cr lab val prinusyr usyr1999 } if `year'==2000 { #delimit ; lab define usyr2000 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-93" 14 "1994-95" 15 "1996-97" 16 "1998-00" ; #delimit cr lab val prinusyr usyr2000 } /* according to NBER documentation, 16 in 2001 is "1998" only */ if `year'==2001 { #delimit ; lab define usyr2001 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-93" 14 "1994-95" 15 "1996-97" 16 "1998-00" ; #delimit cr lab val prinusyr usyr2001 } /* according to NBER documentation, 16 in 2001 is "1998" only */ if `year'==2002 { #delimit ; lab define usyr2002 1 "<1950" 2 "1950-59" 3 "1960-64" 4 "1965-69" 5 "1970-74" 6 "1975-79" 7 "1980-81" 8 "1982-83" 9 "1984-85" 10 "1986-87" 11 "1988-89" 12 "1990-91" 13 "1992-93" 14 "1994-95" 15 "1996-97" 16 "1998-99" 17 "2000-02" ; #delimit cr lab val prinusyr usyr2002 } lab var prinusyr "Year entered US" notes prinusyr: See "arrived" for variable that is consistent over time notes prinusyr: CPS: prinusyr lab var penatvty "Country of birth" #delimit ; lab define cob 57 "United States" 60 "American Samoa" 66 "Guam" 72 "Puerto Rico" 78 "U.S. Virgin Islands" 96 "No coding available" 102 "Austria" 103 "Belgium" 105 "Czechoslovakia" 106 "Denmark" 108 "Finland" 109 "France" 110 "Germany" 116 "Greece" 117 "Hungary" 119 "Ireland/Eire" 120 "Italy" 126 "Holland/Netherlands" 127 "Norway" 128 "Poland" 129 "Portugal" 130 "Azores" 132 "Romania" 134 "Spain" 136 "Sweden" 137 "Switzerland" 138 "Great Britain" 139 "England" 140 "Scotland" 142 "Northern Ireland" 147 "Yugoslavia" 148 "Europe" 155 "Czech Republic" 156 "Slovakia/Slovak Republic" 180 "USSR" 183 "Latvia" 184 "Lithuania" 185 "Armenia" 192 "Russia" 195 "Ukraine" 200 "Afghanistan" 202 "Bangladesh" 205 "Burma" 206 "Cambodia" 207 "China" 209 "Hong Kong" 210 "India" 211 "Indonesia" 212 "Iran" 213 "Iraq" 214 "Israel" 215 "Japan" 216 "Jordan" 217 "Korea/South Korea" 218 "Korea/ South Korea" 221 "Laos" 222 "Lebanon" 224 "Malaysia" 229 "Pakistan" 231 "Philippines" 233 "Saudi Arabia" 234 "Singapore" 237 "Syria" 238 "Taiwan" 239 "Thailand" 240 "Turkey" 242 "Vietnam" 245 "Asia" 252 "Middle East" 253 "Palestine" 300 "Bermuda" 301 "Canada" 304 "North America" 310 "Belize" 311 "Costa Rica" 312 "El Salvador" 313 "Guatemala" 314 "Honduras" 315 "Mexico" 316 "Nicaragua" 317 "Panama" 318 "Central America" 333 "Bahamas" 334 "Barbados" 337 "Cuba" 338 "Dominica" 339 "Dominican Republic" 342 "Haiti" 343 "Jamaica" 351 "Trinidad & Tobago" 353 "Caribbean" 375 "Argentina" 376 "Bolivia" 377 "Brazil" 378 "Chile" 379 "Colombia" 380 "Ecuador" 383 "Guyana" 385 "Peru" 387 "Uruguay" 388 "Venezuela" 389 "South America" 415 "Egypt" 417 "Ethiopia" 421 "Ghana" 427 "Kenya" 436 "Morocco" 440 "Nigeria" 449 "South Africa" 462 "Other Africa" 468 "North Africa" 501 "Australia" 507 "Fiji" 514 "New Zealand" 527 "Pacific Islands" 555 "Other" ; #delimit cr lab val penatvty cob notes penatvty: CPS: penatvty lab var pemntvty "Country birth, mother" lab val pemntvty cob notes pemntvty: CPS: pemntvty lab var pefntvty "Country birth, father" lab val pefntvty cob notes pefntvty: CPS: pefntvty /* Veteran */ if `year'<=1988 { gen byte vet=0 if veteran~=. replace vet=1 if 1<=veteran & veteran<=5 replace vet=. if female==1 } if 1989<=`year' { gen byte vet=0 if veteran~=. replace vet=1 if 1<=veteran & veteran<=5 } lab var vet "Veteran" notes vet: Question not asked consistently of women before 1989 notes vet: CPS: derived from a-vet, peafwhen /* Copyright 2003 CEPR and John Schmitt This file is part of the cepr_org_master.do program. This file and all programs referenced in it are free software. You can redistribute the program or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. */