Tips and Documentation
SF2 Profile
The 2010 Summary File 2 (SF2) profile was developed by the State Data Center (SDC) Network. This profile allows users to run a profile on any race/ethnic group listed in the SF2, as long as there are 100 or more people of that specific group in a particular geographic area. We would like to thank John Blodgett of the University of Missouri for his excellent work converting the SF2 data files to SAS datasets. This has made the job of generating the 2010 SF2 profile much easier and more efficient. We would also like to thank Xan Wedel of the University of Kansas who graciously helped with the SAS coding and proofreading the profile.
Download the SAS programs that can be used to generate the 11-page SF2 profile. A copy of the SF2 profile for Nevada is also provided in the zipped file as an example.
The programs are designed to run in two-phases:
Step 1: Conversion phase: convert SF2 data files to SAS data sets. You can download the 2010 SF2 data files from the census FTP site at ftp://ftp2.census.gov/census_2010/ and run the conversion program (cnvtsf2.sas) to get the data converted to SAS data sets. The cnvtsf2.sas program is attached and can also be accessed at http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/sf22010/Tools.
Step 2: Profile generation phase: Generate the profile using the SAS data files output from Step 1 as input.
- SF2_main_2010_pdf.sas. This is the main SAS program used to run the profile. It is set up so the user can select to run only the section(s) of interest and comment out the other sections. This code controls all of the other modules – you will only change this file when you run the profile. The instructions on how to run the profile are included in the program.
- Genprof1.sas contains the SAS code to generate the General Profile.
- Genprof2.sas contains the SAS code to generate the Age Profile.
- PageTOC.sas contains the SAS code to generate the Table of Contents.
- Formats.sas – This file is used by the main routine. Note that in the program Formats.sas, the specific geography (place and county) is for CA only so you will need to add the codes for your state.
SF1 SAS Profiles for Census 2010
The 2010 Summary File 1 (SF1) profile was developed by the State Data Center (SDC) Network. The 2010 profile generally uses the same formats as the 2000 SF1 profile.
The SAS programs that are used to generate the 58-page SF1 profile are available in the zipped file below. Last revised 8/15/2011.
2010 Census Demographic Profile Template and Production Macro
The California State Census Data Center has prepared a 2-column 2-page Demographic Profile in Excel. Download this file and change the extension from “.xlsx” to “.xlsm” in order to ensure that this is an Excel 7.0 macro file. Also ensure that you have set macros to be enabled.
Directions are contained within the Excel file.
2010 Demographic Profiles
This profile in Excel was provided by the Pennsylvania State Data Center:
The attached workbook produces a one-page profile for a geographic area similar to the 2000 DP-1 profile in Excel for printing or viewing. It also contains a data sheet created from the Access database provided by the Census Bureau with Pennsylvania state, county and county subdivision data.
Pennsylvania used the vlookup function so that you can just type in the name of the geographic area you are interested in (in cell A3) and create the profile for that area. The Pennsylvania State Data Center finds this worksheet useful when providing data profiles to customers or as a quick way to access the data when responding to requests rather than using American FactFinder. The profiles are already formatted to print.