* set it such that the computer does not
* need the operator to hit the return key
* to continue
set more off
* write results to a log file
log using read_in_excel_version_cps87.log,replace
* read in raw data from excel spreadhseet
import excel using cps87.xls, firstrow
* label the variables
label var age "age in years"
label var race "=1 if white non-Hisp, =2 if black non-Hisp, =3 if Hispanic"
label var years_educ "years of competed education"
label var union_status "=1 if in union, =2 otherwise"
label var smsa_size "=1 if largest 19 smsa, =2 if other smsa, =3 not in smsa"
label var region "=1 if northeast, =2 if midwest, =3 if south, =4 if west"
label var weekly_earn "usual weekly earnings, up to $999"
* describe what is in the data set
describe
* get descriptive statistics for all variables
sum
* close log file
log close
* see ya