/* table1.do  '/home/chansen/work/migration/stata'  CBH 
   Created 2/20/2001 Last Revised 2/21/2001 */

/* Generate descriptive statistics reported in Table 1.  Statistics for
   *1987,* 1989, 1996, *1997,* and 1999.  Averages by country reported. */

log using table1.log ,replace

set mem 100m
set more off

cd "DIRECTORY HERE"
use rsa8399n

sort country

/* Descriptive statistics for 1989 */

by country: sum tlf f_lf1 eu_lf1 e_p if trend==1989

/* Descriptive statistics for 1996 */

by country: sum tlf f_lf1 eu_lf1 e_p if trend==1996

/* Descriptive statistics for 1999 */

by country: sum tlf f_lf1 eu_lf1 e_p if trend==1999


log close