There is a SAS program to convert SF1 data (ftped) into a SAS file.
It is available at http://www.sascommunity.org.
One has to log in but it is free.
A search for “sf1” leads to the programmer Mike Zdeb’s profile and his postings.
The most recent posting is the SF1 conversion program.
I tried the program with Delaware data and it is very easy to use and works fine.
For those who do not have SAS, John Blodgett’s extraction program works fine. Output can be in comma delimited, pdf, html, dbf, SAS, etc.
I am grateful to both of these generous persons.
Marie Bousfield
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Eric Kramer
Sent: Monday, July 25, 2011 2:30 PM
To: ctpp-news@chrispy.net
Subject: RE: [CTPP] More on 2010 Census Summary File 1
Does anyone know when Microsoft Access table shells will be available for ACS data?
____________________________
Eric W. Kramer, Ph.D.
Senior Research/Statistical Analyst
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Elaine.Murakami@dot.gov
Sent: Tuesday, June 28, 2011 4:14 PM
To: ctpp-news@chrispy.net
Subject: [CTPP] More on 2010 Census Summary File 1
On Thursday, July 7 , the U.S. Census Bureau will release a 2010 Census Summary File 1 Microsoft Access table shell. The table shell will provide an easier way to access Summary File 1 information from the Census Bureau's FTP site http://www2.census.gov/census_2010/04-Summary_File_1/. Instructions for how to use the shell and work with the information will also be included in the .zip file.
Some of the tables in Summary File 1 of interest to transportation planners include:
P12 Sex by Age (23 age categories)
P14 Sex by Age (Single years 0-19)
P19 Household size and type by presence of children (19 cells)
P28 Household type and Household size (16 cells)
P42 Group Quarters by GQ Type (10 cells)
H3 Housing Units
H12 Average Household Size by Housing Tenure (own/rent)
For more information on which states have been released, please see:
http://2010.census.gov/news/press-kits/summary-file-1.html
Elaine Murakami
FHWA Office of Planning
206-220-4460