8 Sep
2011
8 Sep
'11
6:54 p.m.
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
8 Sep
8 Sep
7:44 p.m.
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
9 Sep
9 Sep
9:25 a.m.
Nancy
Thanks for the pointer to the PUMS. I had overlooked it. BTW there is 5 year
B19019 table available and here is a link to the same table data (
http://bit.ly/q3ONvw ) from AZ (just a couple of counties 2005-2009).
Apologize for the same font size, i just tried to fit it in one page.
Krishnan
On Thu, Sep 8, 2011 at 8:44 PM, Gemignani, Nancy <Nancy.Gemignani(a)dof.ca.gov
wrote:
**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(a)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
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
12:01 p.m.
Ahhh-Sorry - I checked on AFF and table B19019 is not available there - I forgot that some
tables are on the Summary File but not AFF even when it is not a block group table. Very
confusing. From now on I'll check the documentation first. :)
Nancy Gemignani
California State Census Data Center
Demographic Research Unit
(916) 327-0103 ext 2550
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Krishnan Viswanathan
Sent: Friday, September 09, 2011 7:25 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] ACS Household Income by Household size and R Scripts
Nancy
Thanks for the pointer to the PUMS. I had overlooked it. BTW there is 5 year B19019 table
available and here is a link to the same table data ( http://bit.ly/q3ONvw ) from AZ (just
a couple of counties 2005-2009). Apologize for the same font size, i just tried to fit it
in one page.
Krishnan
On Thu, Sep 8, 2011 at 8:44 PM, Gemignani, Nancy
<Nancy.Gemignani@dof.ca.gov<mailto:Nancy.Gemignani@dof.ca.gov>> wrote:
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<tel:%28916%29%20327-0103%20ext%202550>
From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net>
[mailto:ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net>] On
Behalf Of Krishnan Viswanathan
Sent: Thursday, September 08, 2011 4:55 PM
To: ctpp-news@chrispy.net<mailto:ctpp-news@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@chrispy.net<mailto:ctpp-news@chrispy.net>
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
4856
days inactive
4857
days old
3 comments
2 participants
participants (2)
-
Gemignani, Nancy -
Krishnan Viswanathan