The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
American Community Survey Data Users Group
Search for topics, people, or keywords
Sign Up
Log in
Site
Search for topics, people, or keywords
User
Home
Discussion Forum
ACS Resources
Webinars
Conferences
Steering Committee
More
Cancel
Home
Discussion Forum
ACS Resources
Webinars
Conferences
About
More
Cancel
Details
Views
5561 views
Replies
2 replies
Subscribers
541 subscribers
Users
0 members are here
Labels
PUMS
Related Census Bureau Resources
Related Forum Threads
Using the ADJINC variable in 3-year PUMS files
Diana Lavery
over 10 years ago
Has anyone used the ADJINC variable with any of the income variables in the three-year PUMS files?
I'm using the '10-'12 file trying to take the median of the pernp variable by various groups, and the data dictionary says to use the adjinc values to adjust all the pernp values to inflation-adjusted 2012 dollars, but I'm a little confused as to what exactly to do. Here's what I'm currently doing, is this correct?
*2010 record;
if adjinc = 1061121 then pernp_adj = pernp * (1061121/1000000);
*2011 record;
if adjinc = 1039506 then pernp_adj = pernp * (1039506/1000000);
*2012 record;
if adjinc = 1010207 then pernp_adj = pernp * (1010207/1000000);
Thanks,
Diana
Mark Mather
over 10 years ago
Hi Diana!
This looks right. I have just been putting in one simple line of SAS code to adjust for inflation:
pernp = pernp*(adjinc/1000000);
-Mark
Cancel
Up
0
Down
Reply
Cancel
Diana Lavery
over 10 years ago
Hi Mark! Thanks so much, your way is more efficient.
Hope you're doing well.
-Diana
Cancel
Up
0
Down
Reply
Cancel