Art,
If I understand your question, you want to calculate dollars across the years 1980-2013* so that each amount is in the same metric (i.e. 2014 dollars or 1980
dollars)
When we did this we created an calculation based on CPI for the year (http://www.bls.gov/cpi/cpid1402.pdf
Table 24).
*2014 would need to be by month or average for the currently reported months. By multiplying the value of the dollar in the year by the percent to put it all
in 1980$
The exact syntax would depend on your data layout, but if you have year, $ amount, and do a table lookup on year for the CPIAPC index to add it to each row,
you could simply multiply the dollar value by the CPIAPC. Going backwards, i.e. putting it all in 2013 or 2014 dollars, multiply by the CPIAND.
I don’t actually have the file I used, but this data should be good to start.
Year; CPIAPC* AnnAve CPIAND**
|
Year
|
Change from previous year
|
Annual Average
|
Diff from the next year
|
|
|
|
|
|
|
1980
|
13.5
|
82.4
|
-8.5
|
|
1981
|
10.3
|
90.9
|
-5.6
|
|
1982
|
6.2
|
96.5
|
-3.1
|
|
1983
|
3.2
|
99.6
|
-4.3
|
|
1984
|
4.3
|
103.9
|
-3.7
|
|
1985
|
3.6
|
107.6
|
-2.0
|
|
1986
|
1.9
|
109.6
|
-4.0
|
|
1987
|
3.6
|
113.6
|
-4.7
|
|
1988
|
4.1
|
118.3
|
-5.7
|
|
1989
|
4.8
|
124
|
-6.7
|
|
1990
|
5.4
|
130.7
|
-5.5
|
|
1991
|
4.2
|
136.2
|
-4.1
|
|
1992
|
3
|
140.3
|
-4.2
|
|
1993
|
3
|
144.5
|
-3.7
|
|
1994
|
2.6
|
148.2
|
-4.2
|
|
1995
|
2.8
|
152.4
|
-4.5
|
|
1996
|
3
|
156.9
|
-3.6
|
|
1997
|
2.3
|
160.5
|
-2.5
|
|
1998
|
1.6
|
163
|
-3.6
|
|
1999
|
2.2
|
166.6
|
-5.6
|
|
2000
|
3.4
|
172.2
|
-4.9
|
|
2001
|
2.8
|
177.1
|
-2.8
|
|
2002
|
1.6
|
179.9
|
-4.1
|
|
2003
|
2.3
|
184
|
-4.9
|
|
2004
|
2.7
|
188.9
|
-6.4
|
|
2005
|
3.4
|
195.3
|
-6.3
|
|
2006
|
3.2
|
201.6
|
-5.7
|
|
2007
|
2.8
|
207.3
|
-8.0
|
|
2008
|
3.8
|
215.3
|
0.8
|
|
2009
|
-0.4
|
214.5
|
-3.5
|
|
2010
|
1.6
|
218.1
|
-6.9
|
|
2011
|
3.2
|
224.9
|
-4.7
|
|
2012
|
2.1
|
229.6
|
-3.4
|
|
2013
|
1.5
|
233.0
|
|
*CPI Average percent change from past year. (current year – prior year)
**CPI Average percent difference from next year (current year – next year)
If you need 2014, you would need to get the current average for whatever has elapsed (Jan: 233.9; Feb: 234.8; Average=234.3, change from next year: -1.3)
From: SPSSX(r) Discussion [mailto:[hidden email]]
On Behalf Of Art Kendall
Sent: Thursday, March 20, 2014 12:04 PM
To: [hidden email]
Subject: [SPSSX-L] syntax to adjust to constant dollars
Before I spend time writing syntax to do this, I was wondering whether anyone has written syntax to adjust dollar amounts to constant dollars.
I am looking at 1980 to the present.
--
Art Kendall
Social Research Consultants
Art Kendall
Social Research Consultants
View this message in context:
syntax to adjust to constant dollars
Sent from the SPSSX Discussion mailing list archive at Nabble.com.
Locked
