
//importing price deflators

clear
import excel "NIPA2BUI_ImplicitPriceDeflators2000-2018.xls", sheet("Quarterly") firstrow
reshape long YR, i(NAICS) j(datacqtr)
rename YR pricedef
gen naics1 = NAICS
gen naics2 = NAICS 
gen naics3 = NAICS
gen naics4 = NAICS
gen naics5 = NAICS
save "..\..\price_deflators.dta", replace


