clear
set mem 2000m
set matsize 800
set more off
capture log close
set logtype text
set trace off

#delimit;

global path ~;

log using $path/ui/logs/bn_master.log, replace;

/*=======================================
 Program: bn_master.do
 Author:  Avi Ebenstein
 Created: May 2005
 Purpose: Create Stata files from
          data provided by Andy Spizak.
========================================*/

********************;
* Bring in BAM data ;
********************;

insheet
clmdate
cltype
samptype
batch
seq
state
locoff
invid
methinfoobt
citizen
educ
voctech
trainstat
lastempsic
usualocc
ushrwage
seekocc
lohrwage
dob
gender
ethnic
program
cwc
byb
icfilmeth
bri
sepbef
sepaft
sepdatebef
sepdateaft
nonsepbef
nonsepaft
rclstatbef
rclstataft
bpempbef
bpempaft
bpwbef
bpwaft
hqwbef
hqwaft
bpwksbef
bpwksaft
wbabef
wbaaft
mbabef
mbaaft
depbef
depaft
allowbef
allowaft
priempsic
monredet
balbef
balaft
monstatbef
monstataft
totearnbef
totearnaft
earndedbef
earndedaft
othdedincbef
othdedincaft
othdedsbef
othdedsaft
wkfilmeth
origamptpd
wksdenbef
wkdenaft
wsreq
jsregreq
jsreg
jsregdef
jsref
privagreg
privagref
unrefstat
unref
unserv
unastreq
unast
jobcon
prjobcon
wsconinv
wsconok
wsconnotok
wsconunver
actflag
detapp
apprslt
invcomp
invcompdate
supcomp
supcompdate
suplogin
lockid
data_pickup_date
v96

using $path/ui/BN_DATA/rawfiles/dca_master.tbl, delimiter("|");
compress;
save $path/ui/BN_DATA/datafiles/dc_master.dta, replace;

use $path/ui/BN_DATA/datafiles/dc_master.dta, replace;

*do  $path/ui/BN_DATA/dofiles/bn_master_value_labels.do;
*do  $path/ui/BN_DATA/dofiles/bn_master_labels.do;
gen year=substr(clmdate,7,4);
sort state batch;
save $path/ui/BN_DATA/datafiles/dc_master_clean.dta, replace;