Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

Re: st: How do I rebaseline financial data to a new year

 From Austin Nichols To statalist@hsphsun2.harvard.edu Subject Re: st: How do I rebaseline financial data to a new year Date Thu, 1 Sep 2011 12:02:11 -0400

```Art <agibb@email.unc.edu> :
No, if a variable is measured in 2009 dollars in every year, you
divide by 1.245859 to get 2000 dollars.
For example, the 2009 poverty line for one person was \$11161, 1.2458
times the 2000 value of 8959.
(The US poverty threshold is intended to be constant in real terms.)

If every year is measured in nominal dollars, you divide each by the
appropriate factor.
You may also want to read http://www.bls.gov/cpi/cpifaq.htm

On Thu, Sep 1, 2011 at 11:45 AM, Gibb, Art <agibb@email.unc.edu> wrote:
> Austin,
> Thanks for the quick reply. So then I would have to divide all values for all years other than 2000 by this constant, correct?
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Austin Nichols
> Sent: Thursday, September 01, 2011 11:30 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: How do I rebaseline financial data to a new year
>
> Art Gibb <agibb@email.unc.edu>:
> There is -cpigen- on SSC which I note is sadly out of date--I will
> update it shortly.
> You can also do:
>
> ssc inst freduse
> mata mata mlib index
> freduse CPIAUCNS, clear
> su CPIAUCNS if year(daten)==2000
> g cpi2000=CPIAUCNS/r(mean)
> su cpi2000 if year(daten)==2009
>
> to find that the CPI-U was 1.245859 times higher in 2009 than in 2000.
>
> On Thu, Sep 1, 2011 at 11:15 AM, Art Gibb <agibb@email.unc.edu> wrote:
>> I'm using two sets of financial data, one in constant 2009\$US, the other in
>> constant 2000\$US. The data is TSCS, covering a large number of countries
>> from 1989-2009.  How do I convert the constant 2009\$ data to constant 2000\$?
>> I imagine this is a fairly common requirement - has anyone written code that
>> will do this that I can use as an example?
>>
>> Many thanks!

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```