use "C:\Users\user5-098\Desktop\20201106-20201112\财政支出.dta"
reshape long expenditure,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\财政支出.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\常住人口.dta", clear
reshape long population,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\常住人口.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\地区生产总值.dta", clear
reshape long gdp,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\地区生产总值.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\房地产开发投资.dta", clear
reshape long houseinvest,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\房地产开发投资.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\进出口贸易.dta", clear
reshape long trade,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\进出口贸易.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\面积.dta", clear
reshape long area,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\面积.dta", replace
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\进出口贸易.dta"
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\房地产开发投资.dta",nogen
drop _merge
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\地区生产总值.dta"
drop _merge
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\常住人口.dta"
drop _merge
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\财政支出.dta"
save total
egen id = group(地区)
xtset id year
reg gdp area trade houseinvest population expenditure
xtreg gdp area trade houseinvest population expenditure,vce(cluster id)
gen dgdp=d.gdp
xtreg dgdp area trade houseinvest population expenditure,vce(cluster id)
xtreg gdp area trade houseinvest population expenditure,fe r
xtreg gdp area trade houseinvest population expenditure i.id,r
tab year,gen(year)
xtreg gdp area trade houseinvest population year1-year10,fe r
reshape long expenditure,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\财政支出.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\常住人口.dta", clear
reshape long population,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\常住人口.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\地区生产总值.dta", clear
reshape long gdp,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\地区生产总值.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\房地产开发投资.dta", clear
reshape long houseinvest,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\房地产开发投资.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\进出口贸易.dta", clear
reshape long trade,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\进出口贸易.dta", replace
use "C:\Users\user5-098\Desktop\20201106-20201112\面积.dta", clear
reshape long area,i(地区) j(year)
save "C:\Users\user5-098\Desktop\20201106-20201112\面积.dta", replace
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\进出口贸易.dta"
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\房地产开发投资.dta",nogen
drop _merge
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\地区生产总值.dta"
drop _merge
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\常住人口.dta"
drop _merge
merge 1:1 地区 year using "C:\Users\user5-098\Desktop\20201106-20201112\财政支出.dta"
save total
egen id = group(地区)
xtset id year
reg gdp area trade houseinvest population expenditure
xtreg gdp area trade houseinvest population expenditure,vce(cluster id)
gen dgdp=d.gdp
xtreg dgdp area trade houseinvest population expenditure,vce(cluster id)
xtreg gdp area trade houseinvest population expenditure,fe r
xtreg gdp area trade houseinvest population expenditure i.id,r
tab year,gen(year)
xtreg gdp area trade houseinvest population year1-year10,fe r
