the problem I have was 'matching' the CPI data to the records - I have 400,000 records and was not sure how to match the right CPI to each one (or, how to create 400,000 CPI records in the same order as the other observations).
Is there a straight forward way to do that?
 
"I often see problems in the world and wonder why someone doesn't fix them. Then I realize that I am someone, and that makes me feel bad because it is all my fault."
http://dilbert.com/blog/entry/fixing_the_world/




From: Allin Cottrell <cottrell@wfu.edu>
To: Gretl list <gretl-users@lists.wfu.edu>
Sent: Saturday, April 11, 2009 4:15:01 AM
Subject: Re: [Gretl-users] Correcting for inflation

On Fri, 10 Apr 2009, Raz Lev wrote:

> I am trying to convert data to account for inflation.

> I have an excel (or variable, whichever is better) with the
> cumulative inflation for every quarter between 1980 and 1990 (my
> period of interest) and in gretl data about salaries that
> contain, amongst else, the wage, and the year and the quarter in
> which the sample was taken.

The usual precedure for deflating a nominal variable is simply to
divide by a price index (with a possible scale factor to equate
the real and nominal values in a chosen base period).  For
example, suppose I have nominal wage bill data and data on the
CPI:

            wages          CPI
1983:1      1629.5      98.0000
1983:2      1661.8      99.1333
1983:3      1699.0    100.1000
1983:4      1748.1    101.1000
1984:1      1794.0    102.5333
1984:2      1837.9    103.5000
1984:3      1877.3    104.4000
1984:4      1911.1    105.3000

Then I might choose a base period -- say, 1993:3, and do

  genr realwages = wages * CPI[1983:3] / CPI

Allin
_______________________________________________
Gretl-users mailing list
Gretl-users@lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users