Appendix A: Description of SAS Programs Used to Replicate Ahmed and Robinson's 1980-1990 Emigration Estimates

Step
#
Description SAS Programs Data
Input Output

(*)existing data

Pre-1980 Selected
1   Acquire 1980 base population adjusted for cases with unknown country of birth. FB80CEN fb80cen.dat * fb80t.dat *
fb80m.dat *
fb80f.dat *
2   Create a file containing the foreign-born population enumerated in the 1990 census. Recode the country of birth from 111 categories to 40. d_fb90_c40 fb111_ad.dat * d_fb90_c40.dat
3   Calculate the preliminary number of emigrants for the total population that entered before 1980 by age, sex, country of birth, and period of entry. d_FB_EMIG d_fb90_c40.dat
d_fb80f.dat
d_fbemig_t.dat
d_fbemig_m.dat
d_fbemig_f.dat
4   Recreate the number of emigrants and the emigration rate for SELECTED countries by age, sex, and race group, and period of entry. d_Fb_1980_select d_fbemig_m.dat
d_fbemig_f.dat
d_Fb_1980_sel.dat
d_Fb_1980_sel_race.dat
d_Fb_1980_sel_rate.dat
d_Fb_70_79_sel.dat
1980-1990 Selected
5   Calculate the proportional distribution of the 1980-1990 entrant foreign born population enumerated in 1990, the average length of stay, the mid-point of age in 1990, and the average age at entry. d_Fb_8090_midpt d_fb90_c40.dat d_Fb_8090_midpt.dat
6   Estimate the 1980-1990 number of emigrants (and rates) for SELECTED countries that entered 1980-1990 by age, sex, and race group. d_Fb_emig_8090 d_fb90_c40.dat
d_Fb_8090_midpt.dat
d_Fb_70_79_sel.dat
d_SR_1990_15.prn *
d_emig_8090_age.dat
d_ERSR_8090_age.dat
1980-1990 Non-Selected
7   Create data sets for the 1980-1990 entrants enumerated in 1990 by age, sex, country of birth, and period of entry NON-selected countries. d_fb_8090_nonsel d_fb90_c40.dat d_fb_8090_nonsel.dat
8   Estimate the number of 1980-1990 entrant emigrants for NON-selected countries by age, sex, and race. d_Fb_emig_8090_nonsel d_ERSR_8090_age.dat
d_Fb_8090_nonsel.dat
d_Fb_emig_8090_nonsel.dat
Pre-1980 Non-Selected
9   Create data set that contains the 1980 enumerated foreign born that entered before 1980 for NON-selected countries by age, sex, race, and period of entry. d_Fb_1980_nonsel.sas d_fbemig_m.dat
d_fbemig_f.dat
d_Fb_1980_nonsel.dat
10   Estimate the number of before 1980 entrant emigrants for NON-selected by age and race. d_Fb_emig_1980_nonsel d_Fb_1980_nonsel.dat
d_Fb_1980_sel_rate.dat
d_Fb_emig_1980_nonsel.dat
Final Estimates
11   Merge four files with the estimated number of emigrants for the before 1980 and 1980-1990 entrants and selected/non-selected countries to estimate the 1980-1990 emigrants by age, sex, and race. d_Fb_emig_final d_Fb_1980_sel.dat
d_emig_8090_age.dat
d_Fb_emig_8090_nonsel.dat
d_Fb_emig_1980_nonsel.dat
d_Fb_emig_final.dat
d_Fb_emig_94.dat

Return to working paper:

Page Last Revised - May 27, 2022