Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | "Gibb, Art" <agibb@email.unc.edu> |
| To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
| Subject | RE: st: How do I rebaseline financial data to a new year |
| Date | Thu, 1 Sep 2011 16:47:37 +0000 |
Got it - I've got one variable (military aid) in constant 2009 dollars for all years, and a second (GDP) in constant 2000 dollars, so I'll convert the military aid data by dividing by the 1.2458 constant. Many thanks for the assist!! R/ Art -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Austin Nichols Sent: Thursday, September 01, 2011 12:02 PM To: statalist@hsphsun2.harvard.edu Subject: Re: st: How do I rebaseline financial data to a new year 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/ * * 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/