EnVaTut1

*2)

clear all
cd "C:\Users\PCL161\Desktop\Tutorial 1"
set more off


*first data set prices.dta
clear all

import excel using rock_view_prices.xlsx, firstrow
destring, replace
save prices.dta, replace


*second data set characteristics.dta

clear all

import excel using rock_view_characteristics.xlsx, firstrow
destring, replace
save characteristics.dta, replace


*3)

clear all

use prices.dta
merge 1:1 id using characteristics
drop _merge


*4)

drop if price==.
drop if view==.


*5)

generate price2 = price+diff
rename price price1
generate age = 2005 - yearbuilt


*6)

label variable price2 "asking price"
label variable price1 "selling price"
label variable age "age"
*Den rest noch nachtragen

label define yesno 1 "yes" 0 "no"
label values garage sub view yesno


*7)

order id price1 price2 diff view

*8)

save workingsample.dta, replace