* get data for Rob
* changed march 25, 2008 to include lat/lon and save in Stata9 format

cd /afs/econ/data/bayerp/Alvin
clear
set mem 1800m

* load data for sample year (2000)
use "/afs/econ.duke.edu/data/bayerp/California/match00_full.dta"

* drop sensitive vars, 
drop sr_buyer sr_seller sa_parcel_nbr_primary sa_owner_1 sa_owner_1_et_flag sa_owner_1_first sa_owner_1_group sa_owner_1_last sa_owner_1_mid sa_owner_1_pre sa_owner_1_sp_first sa_owner_1_sp_mid sa_owner_1_sp_suf sa_owner_1_suf sa_owner_2 sa_owner_2_et_flag sa_owner_2_first sa_owner_2_last sa_owner_2_mid sa_owner_2_sp_first sa_owner_2_sp_mid sa_owner_2_suf sa_site_house_nbr sa_site_fraction sa_site_dir sa_site_street_name sa_site_suf sa_site_post_dir sa_mail_house_nbr sa_mail_fraction sa_mail_dir sa_mail_street_name sa_mail_suf sa_mail_post_dir sa_mail_unit_pre sa_mail_unit_val sa_lgl_dscrptn sa_lot_nbr_1 sa_map_grid_new sa_map_grid_old sa_map_page_new sa_map_page_old sa_phone_nbr  

* save sample year for Rob
saveold "/afs/econ/data/webfiles/Alvin/match00_full_Rob.dta"    , replace

clear
* load data for all years.  
* This data set was created using ...
* It appends the annual data sets and keeps a subset of the vars. 
* See /afs/econ/data/bayerp/Cal_Dataset_Append/append_4_2-_07.do for details
use "/afs/econ.duke.edu/data/bayerp/Cal_Dataset_Append/fullmatch_90_04.dta"

* drop sensitive vars
drop sr_buyer sr_seller sa_parcel_nbr_primary sa_site_street_name parcelst parcelnum 

* save all_years for Rob
saveold "/afs/econ/data/webfiles/Alvin/fullmatch_90_04_Rob.dta"    , replace