The Missouri Census Data Center had created data set versions of the 2012 1-year ACS base/summary tables. And MCDC has completed using those detailed tables in order to create ACS Profiles and ACS Trends report products (use the first and third links from the “Quick Links” box on the home page for access to the menu pages). We have done considerable work on the code we use to create these derived variables, trying to avoid using tables with a higher probability of having suppressed values.
You can also get access to these data in a single data set, usmcdcprofiles in the acs2012 data directory. Access this data set with 7750 geographic summaries (rows) and 1057 data items (variables/columns). The latter include the margin-of-error values and calculated percentage variables for all variable that are counts (so you get, for example, Poor, Poor_moe and PctPoor (as well as PovUniverse). There are numerous ways to access this data set (which might require you to skim the Dexter Quick Start Guide – linked to from the Dexter query form):
1. You can navigate the old fashioned way(s). Click sequence:
a. American Community Survey home page - http://mcdc.missouri.edu/pub/data/acs/Readme.shtml - from the Navy blue navigation box on our home page.
b. Access Data from the section index at the top of the page .
c. Acs2012 data directory link.
d. Usmcdcprofiles.sas7bdat data set. (Alternately, choose Datasets.html followed by the usmcdcprofiles link in col. 1 of that page).
2. Access the ACS Profiles report application and choose 1-year periods/2012 from the Select Period drop-down. Complete your specs by completing selecting an area type, and subsequent choices that vary based on area type (aka “summary level”). Run the report. (Alternatively, just click on the “Sample Profile Report” link which appear just below the 1. Select period: line. From the generated report page note the gray Other formats box at upper right and the link labeled Extract data via Dexter at the bottom of that box. This will invoke Dexter and pre-select the data directory and data set.
3. Go to the Whatsnew page (link again is in navy blue navigation box at upper left of mcdc home page) and note the article posted 10-07-2012. In the first paragraph it provides you with a direct link to the “link to the Dexter access” to the relevant data set.