RE: [CTPP] ACS Household Income by Household size and RScripts

Just as a reminder, I find it very easy to use the IPUMS http://usa.ipums.org/usa/sda/ for generating on-demand tables from PUMS. We have an archived webinar on using IPUMS at: http://ctpp.transportation.org/Pages/webinardirectory.aspx April 2009 You can group, and re-group, the income variable into categories that make sense for the area of interest. -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Gyanesh Lama Sent: Friday, September 09, 2011 11:09 AM To: ctpp-news(a)chrispy.net; Nancy Gemignani Subject: RE: [CTPP] ACS Household Income by Household size and RScripts To add to Nancy's comment, it is fairly easy to create Household income x HH size variable from ACS PUMS. Variables are NP (number of persons in household) and HINCP(Household income (past 12 months)). Gyanesh Lama East-West Gateway Council of Governments Department of Research One Memorial Drive, Ste. 1600 St. Louis, MO 63102 1. Krishnan, you are correct, B19019 is the only table combining income and household size. I'm not familiar with "IPF" but you could create a tabulation of household ranges by household size using the PUMS file for the ACS. As a side note, Table B19019 is not available in the 5-year ACS. The 5-year has only B19119, Family income by family size. So, you cannot even get table B19019 for places below 20,000 pop. Nancy Gemignani California State Census Data Center Demographic Research Unit Department of Finance 915 L Street, 8th Floor Sacramento, CA 95814 (916) 327-0103 ext 2550 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Krishnan Viswanathan Sent: Thursday, September 08, 2011 4:55 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] ACS Household Income by Household size and R Scripts This is a two part question: 1. AFAIK there is no direct Household income x HH size table available in the ACS. The only thing that is available is Table B19019 (Median HH income x HH Size). Am i correct? And the only way to obtain the desired HH Inc x HH size table is via IPF. If others have a better idea please let me know. 2. Has anyone written the R equivalent of the eak_0{n}.sas to read the summary files available here: http://www2.census.gov/acs2005_2009_5yr/summaryfile/UserTools/? If anyone has, do you mind sharing with me? TIA, Krishnan -- Krishnan Viswanathan 1101 High Meadow Dr Tallahassee FL 32311 _______________________________________________ ctpp-news mailing list ctpp-news(a)chrispy.net http://www.chrispy.net/mailman/listinfo/ctpp-news