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(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Eric Kramer Sent: Monday, July 25, 2011 2:30 PM To: ctpp-news(a)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 PAG_logotype 177 N. Church Ave, Suite 405 Tucson, AZ 85701 (520) 792-1093 x506 (tel) (520) 620-6981 (fax) www.pagnet.org ekramer(a)pagnet.org From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Elaine.Murakami(a)dot.gov Sent: Tuesday, June 28, 2011 4:14 PM To: ctpp-news(a)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