---------------------------------------------------------------------------------------------------------------------------------- name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/fred2dta.log log type: text opened on: 17 Jul 2016, 12:11:53 . /*****************************************************************************/ > /*** ANNUAL ***/ > /*** Civilian Unemployment Rate > 2015-11: 4.8 Percent (+ see more) > Monthly, Not Seasonally Adjusted, UNRATENSA, Updated: 2015-12-04 8:01 AM CST > ***/ > freduse UNRATENSA, clear; (822 observations read) . gen datey = yofd(daten); . rename UNRATENSA ur; . collapse ur, by(datey); . drop if datey == 2015; (1 observation deleted) . la var ur "yearly averages of monthly values"; . save `tempdata'`prg'_yearly_data, replace; (note: file ../temp/fred2dta_yearly_data.dta not found) file ../temp/fred2dta_yearly_data.dta saved . /*****************************************************************************/ > /*** QUARTERLY ***/ > /*** Nonfarm Business Sector: Implicit Price Deflator > 2015:Q2: 108.951 Index 2009=100 (+ see more) > Quarterly, Seasonally Adjusted, IPDNBS, Updated: 2015-09-02 10:01 AM CDT > ***/ > /****************************************************************************/ > freduse IPDNBS, clear; (277 observations read) . gen dateq = qofd(daten); . format dateq %tq; . drop daten date; . rename IPDNBS ipd; . /* implicit price deflator */ > > save `tempdata'`prg'_quarterly_data, replace; (note: file ../temp/fred2dta_quarterly_data.dta not found) file ../temp/fred2dta_quarterly_data.dta saved . /*** END QUARTERLY ***/ > > /****************************************************************************/ > /*** MONTHLY ***/ > /*** Consumer Price Index for All Urban Consumers: All Items > 2015-06: 237.786 Index 1982-1984=100 (+ see more) > Monthly, Seasonally Adjusted, CPIAUCSL, Updated: 2015-07-17 7:56 AM CDT > ***/ > /****************************************************************************/ > freduse CPIAUCSL, clear; (834 observations read) . gen datem = mofd(daten); . format datem %tm; . drop date daten; . rename CPIAUCSL cpi; . /* Make index reflect Jan 2015 dollars */ > gen temp = cpi if datem == ym(2015,1); (833 missing values generated) . egen temp2 = max(temp); . replace cpi = 100*cpi/temp2; (834 real changes made) . drop temp temp2; . /* Jan 1979 dollars */ > gen temp = cpi if datem == ym(1979,1); (833 missing values generated) . egen temp2 = max(temp); . gen cpi_1979 = 100*cpi/temp2; . drop temp temp2; . la var cpi_1979 "Index (1979m1=100)"; . la var cpi "Index (2015m1=100)"; . save `tempdata'`prg'_monthly_data.dta, replace; (note: file ../temp/fred2dta_monthly_data.dta not found) file ../temp/fred2dta_monthly_data.dta saved . /*** Interpolate Quarterly Data ***/ > use `tempdata'`prg'_quarterly_data, clear; . gen quarter = quarter(dofq(dateq)); . gen year = year(dofq(dateq)); . expand 3; (554 observations created) . sort year quarter; . by year: gen month = _n; . by year quarter: gen middle = _n; . replace ipd = . if middle != 2; (554 real changes made, 554 to missing) . gen datem = ym(year,month); . ipolate ipd datem, gen(iipd) epolate; . gen temp = iipd if datem == ym(2015,1); (830 missing values generated) . egen temp2 = max(temp); . replace iipd = 100*iipd/temp2; (831 real changes made) . drop temp temp2; . la var iipd "Index (2015m1=100); Interpolated (from quarterly) NBS Implicit Price Deflator"; . keep iipd datem; . format datem %tm; . merge 1:1 datem using `tempdata'`prg'_monthly_data, nogen; Result # of obs. ----------------------------------------- not matched 3 from master 0 from using 3 matched 831 ----------------------------------------- . save `tempdata'`prg'_monthly_data.dta, replace; file ../temp/fred2dta_monthly_data.dta saved . /*** END MONTHLY ***/ > > log close; name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/fred2dta.log log type: text closed on: 17 Jul 2016, 12:11:55 ----------------------------------------------------------------------------------------------------------------------------------