read80.do - reads the state-specific files of the 1980 5% extracts (available from ICPSR), does minimal data cleaning, merges all state-specific files. The output is all80.dta. Takes as input:
i. Census of Population and Housing, 1980 [United States]: Public Use Microdata Sample (A Sample): 5-Percent Sample (ICPSR 8101). Download it here.
read_all80.sas, which creates all80.sas7bdat. Takes as input all80.dta.
Run the scripts provided by Card.
i. np2.sas - creates a working data set of wage-earners age 18+, with recodes, etc. This is np80.sas7bdat. These data are used to build wage outcomes. Takes as input all80.sas7bdat. *reads the code in smsarecode80.sas to re-code msa's.
ii. allnp2.sas - creates a working data set of EVERYONE age 18+, with recodes, etc. This is supp80.sas7bdat. These data are used to build supply variables. Takes as input all80.sas7bdat. *reads the code in smsarecode80.sas to re-code msa's.
iii. cell1.sas - creates a big summary of data by cell ==> bigcells.sas7bdat. Takes as input np80.sas7bdat.
iv.t1.sas- creates a big summary of data by cell ==> allcells.sas7bdat. Takes as input supp80.sas7bdat.
v. supply1.sas - gets supply measures ==> cellsupply.sas7bdat. Takes as input np80.sas7bdat.
vi. imm1.sas - gets counts of immigrants by sending country in each city ==>ic_city.sas7bdat (IC is Card's classification of sending countries). Takes as input `supp80.sas7bdat.
vii.indist.sas - gets fraction of workers in MFG by city. Takes as input np80.sas7bdat.
Export some datasets to Stata:
i. cell1_to_stata.sas - creates datasets on wages of immigrants and natives by education class. Exports them to Stata (1980_bigcells_new1.dta, 1980_bigcells_new2.dta, nw80.dta, iw80.dta, nw801.dta, nw802.dta, nw803.dta, nw804.dta, iw801.dta, iw802.dta, iw803.dta, iw804.dta). Takes as input bigcells.sas7bdat.
ii. t1_to_stata.sas - creates 1980_allcells_new2.dta. Takes as input allcells.sas7bdat
iii. indist_to_stata.sas - creates 1980_mfg.dta. Takes as input mfg.sas7bdat
1990
read90.do - reads the state-specific files of the 1990 5% extracts (available from ICPSR), does minimal data cleaning, merges all state-specific files. The output is all90.dta. Takes as input:
i. Census of Population and Housing, 1990 [United States]: Public Use Microdata Sample: 5-Percent Sample (ICPSR 9952). Download it here.
read_all90.sas, which creates all90.sas7bdat. Takes as input all90.dta.
Run the scripts provided by Card.
i. np2.sas - creates a working data set of wage-earners age 18+, with recodes, etc. This is np90.sas7bdat. These data are used to build wage outcomes. Takes as input all90.sas7bdat. *reads the code in smsarecode90.sas to re-code msa's.
ii. allnp2.sas- creates a working data set of EVERYONE age 18+, with recodes, etc. This is supp90.sas7bdat. These data are used to build supply variables. Takes as input all90.sas7bdat. *reads the code in smsarecode90.sas to re-code msa's.
iii. cell1.sas - creates a big summary of data by cell ==> bigcells.sas7bdat. Takes as input np90.sas7bdat.
iv.t1.sas- creates a big summary of data by cell ==> allcells.sas7bdat. Takes as input supp90.sas7bdat.
v. supply1.sas - gets supply measures ==> cellsupply.sas7bdat. Takes as input np90.sas7bdat.
vi. imm1.sas - gets counts of immigrants by sending country in each city ==>ic_city.sas7bdat (IC is Card's classification of sending countries). Takes as input `supp90.sas7bdat.
vii. indist.sas - gets fraction of workers in MFG by city. Takes as input np90.sas7bdat.
Export some datasets to Stata:
i. cell1_to_stata.sas - creates datasets on wages of immigrants and natives by education class. Exports them to Stata (1990_bigcells_new1.dta, 1990_bigcells_new2.dta, nw90.dta, iw90.dta, nw901.dta, nw902.dta, nw903.dta, nw904.dta, iw901.dta, iw902.dta, iw903.dta, iw904.dta). Takes as input bigcells.sas7bdat.
ii. t1_to_stata.sas - creates 1990_allcells_new2.dta. Takes as input allcells.sas7bdat
iii. indist_to_stata.sas - creates 1990_mfg.dta. Takes as input mfg.sas7bdat
2000
read2000.do - reads the state-specific files of the 2000 5% extracts (available from ICPSR), does minimal data cleaning, merges all state-specific files. The output is all2000.dta. Takes as input:
i. Census of Population and Housing, 2000 [United States]: Public Use Microdata Sample: 5-Percent Sample (ICPSR 13568). Download it here.
read_all2000.sas, which creates all2000.sas7bdat. Takes as input all2000.dta.
Run the scripts provided by Card.
i. np2.sas - creates a working data set of wage-earners age 18+, with recodes, etc. This is np2000.sas7bdat. These data are used to build wage outcomes. Takes as input all2000.sas7bdat.
ii. allnp2.sas- creates a working data set of EVERYONE age 18+, with recodes, etc. This is supp2000.sas7bdat. These data are used to build supply variables. Takes as input all2000.sas7bdat.
iii. cell1.sas - creates a big summary of data by cell ==> bigcells.sas7bdat. Takes as input np2000.sas7bdat.
iv. t1.sas- creates a big summary of data by cell ==> allcells.sas7bdat. Takes as input supp2000.sas7bdat.
v. supply1.sas - gets supply measures ==> cellsupply.sas7bdat. Takes as input np2000.sas7bdat.
vi. imm3.sas - gets counts of immigrants by sending country in each city ==> ic_citynew.sas7bdat (IC is Card's classification of sending countries). Takes as input supp2000.sas7bdat.
vii. imm2.sas - gets a count of immigrants present in 2000 by IC - this is used to construct the instrumental variable ==> byicnew.sas7bdat. Takes as input supp2000.
viii. inflow3.sas - constructs the supply push instrument by "education and experience cell" and city. This is newflows.sas7bdat'. Takes as inputic_city.sas7bdat(output ofimm1.sas' in 1980) and byicnew.sas7bdat (output of imm2.sas in 2000).
Export some datasets to Stata:
i. cell1_to_stata - creates datasets on wages of immigrants and natives by education class. Exports them to Stata (2000_bigcells_new1.dta, 2000_bigcells_new2.dta, nw.dta, iw.dta, nw.dta, nw.dta, nw.dta, nw.dta, iw.dta, iw.dta, iw.dta, iw.dta). Takes as input bigcells.sas7bdat.
ii. t1_to_stata - creates 2000_allcells_new1.dta and 2000_allcells_new2.dta. Takes as input allcells.sas7bdat.
iii. inflow3_to_stata - exports `newflows.sas7bdat' to dta.
Replicate Table 6 of Card (2009)
table6.do - replicates Table 6 of Card (2009) and constructs the dataset input_card.dta. Takes as input the Stata datasets exported from SAS (cited above) for 1980, 1990, and 2000.
1980
read80.do
- reads the state-specific files of the 1980 5% extracts (available from ICPSR), does minimal data cleaning, merges all state-specific files. The output isall80.dta
. Takes as input:i. Census of Population and Housing, 1980 [United States]: Public Use Microdata Sample (A Sample): 5-Percent Sample (ICPSR 8101). Download it here.
read_all80.sas
, which createsall80.sas7bdat
. Takes as inputall80.dta
.Run the scripts provided by Card. i.
np2.sas
- creates a working data set of wage-earners age 18+, with recodes, etc. This isnp80.sas7bdat
. These data are used to build wage outcomes. Takes as inputall80.sas7bdat
. *reads the code insmsarecode80.sas
to re-code msa's.ii.
allnp2.sas
- creates a working data set of EVERYONE age 18+, with recodes, etc. This issupp80.sas7bdat
. These data are used to build supply variables. Takes as inputall80.sas7bdat
. *reads the code insmsarecode80.sas
to re-code msa's.iii.
cell1.sas
- creates a big summary of data by cell ==>bigcells.sas7bdat
. Takes as inputnp80.sas7bdat
.iv.
t1.sas
- creates a big summary of data by cell ==>allcells.sas7bdat
. Takes as inputsupp80.sas7bdat
.v.
supply1.sas
- gets supply measures ==>cellsupply.sas7bdat
. Takes as inputnp80.sas7bdat
.vi.
imm1.sas
- gets counts of immigrants by sending country in each city ==>ic_city.sas7bdat
(IC is Card's classification of sending countries). Takes as input `supp80.sas7bdat.vii.
indist.sas
- gets fraction of workers in MFG by city. Takes as inputnp80.sas7bdat
.Export some datasets to Stata: i.
cell1_to_stata.sas
- creates datasets on wages of immigrants and natives by education class. Exports them to Stata (1980_bigcells_new1.dta
,1980_bigcells_new2.dta
,nw80.dta
,iw80.dta
,nw801.dta
,nw802.dta
,nw803.dta
,nw804.dta
,iw801.dta
,iw802.dta
,iw803.dta
,iw804.dta
). Takes as inputbigcells.sas7bdat
.ii.
t1_to_stata.sas
- creates1980_allcells_new2.dta
. Takes as inputallcells.sas7bdat
iii.
indist_to_stata.sas
- creates1980_mfg.dta
. Takes as inputmfg.sas7bdat
1990
read90.do
- reads the state-specific files of the 1990 5% extracts (available from ICPSR), does minimal data cleaning, merges all state-specific files. The output isall90.dta
. Takes as input:i. Census of Population and Housing, 1990 [United States]: Public Use Microdata Sample: 5-Percent Sample (ICPSR 9952). Download it here.
read_all90.sas
, which createsall90.sas7bdat
. Takes as inputall90.dta
.Run the scripts provided by Card. i.
np2.sas
- creates a working data set of wage-earners age 18+, with recodes, etc. This isnp90.sas7bdat
. These data are used to build wage outcomes. Takes as inputall90.sas7bdat
. *reads the code insmsarecode90.sas
to re-code msa's.ii.
allnp2.sas
- creates a working data set of EVERYONE age 18+, with recodes, etc. This issupp90.sas7bdat
. These data are used to build supply variables. Takes as inputall90.sas7bdat
. *reads the code insmsarecode90.sas
to re-code msa's.iii. cell1.sas - creates a big summary of data by cell ==>
bigcells.sas7bdat
. Takes as inputnp90.sas7bdat
.iv.
t1.sas
- creates a big summary of data by cell ==>allcells.sas7bdat
. Takes as inputsupp90.sas7bdat
.v.
supply1.sas
- gets supply measures ==>cellsupply.sas7bdat
. Takes as inputnp90.sas7bdat
.vi.
imm1.sas
- gets counts of immigrants by sending country in each city ==>ic_city.sas7bdat
(IC is Card's classification of sending countries). Takes as input `supp90.sas7bdat.vii.
indist.sas
- gets fraction of workers in MFG by city. Takes as inputnp90.sas7bdat
.Export some datasets to Stata: i.
cell1_to_stata.sas
- creates datasets on wages of immigrants and natives by education class. Exports them to Stata (1990_bigcells_new1.dta
,1990_bigcells_new2.dta
,nw90.dta
,iw90.dta
,nw901.dta
,nw902.dta
,nw903.dta
,nw904.dta
,iw901.dta
,iw902.dta
,iw903.dta
,iw904.dta
). Takes as inputbigcells.sas7bdat
.ii.
t1_to_stata.sas
- creates1990_allcells_new2.dta
. Takes as inputallcells.sas7bdat
iii.
indist_to_stata.sas
- creates1990_mfg.dta
. Takes as inputmfg.sas7bdat
2000
read2000.do
- reads the state-specific files of the 2000 5% extracts (available from ICPSR), does minimal data cleaning, merges all state-specific files. The output isall2000.dta
. Takes as input:i. Census of Population and Housing, 2000 [United States]: Public Use Microdata Sample: 5-Percent Sample (ICPSR 13568). Download it here.
read_all2000.sas
, which createsall2000.sas7bdat
. Takes as inputall2000.dta
.Run the scripts provided by Card. i.
np2.sas
- creates a working data set of wage-earners age 18+, with recodes, etc. This isnp2000.sas7bdat
. These data are used to build wage outcomes. Takes as inputall2000.sas7bdat
.ii.
allnp2.sas
- creates a working data set of EVERYONE age 18+, with recodes, etc. This issupp2000.sas7bdat
. These data are used to build supply variables. Takes as inputall2000.sas7bdat
.iii.
cell1.sas
- creates a big summary of data by cell ==>bigcells.sas7bdat
. Takes as inputnp2000.sas7bdat
.iv.
t1.sas
- creates a big summary of data by cell ==>allcells.sas7bdat
. Takes as inputsupp2000.sas7bdat
.v.
supply1.sas
- gets supply measures ==>cellsupply.sas7bdat
. Takes as inputnp2000.sas7bdat
.vi.
imm3.sas
- gets counts of immigrants by sending country in each city ==>ic_citynew.sas7bdat
(IC is Card's classification of sending countries). Takes as inputsupp2000.sas7bdat
.vii.
imm2.sas
- gets a count of immigrants present in 2000 by IC - this is used to construct the instrumental variable ==>byicnew.sas7bdat
. Takes as inputsupp2000
.viii.
inflow3.sas
- constructs the supply push instrument by "education and experience cell" and city. This isnewflows.sas7bdat'. Takes as input
ic_city.sas7bdat(output of
imm1.sas' in 1980) andbyicnew.sas7bdat
(output ofimm2.sas
in 2000).Export some datasets to Stata: i.
cell1_to_stata
- creates datasets on wages of immigrants and natives by education class. Exports them to Stata (2000_bigcells_new1.dta
,2000_bigcells_new2.dta
,nw.dta
,iw.dta
,nw.dta
,nw.dta
,nw.dta
,nw.dta
,iw.dta
,iw.dta
,iw.dta
,iw.dta
). Takes as inputbigcells.sas7bdat
.ii.
t1_to_stata
- creates2000_allcells_new1.dta
and2000_allcells_new2.dta
. Takes as inputallcells.sas7bdat
.iii.
inflow3_to_stata
- exports `newflows.sas7bdat' to dta.Replicate Table 6 of Card (2009)
table6.do
- replicates Table 6 of Card (2009) and constructs the datasetinput_card.dta
. Takes as input the Stata datasets exported from SAS (cited above) for 1980, 1990, and 2000.