X Samples: Dexter Queries With Detailed Descriptions
Index to the xsamples Mini-tutorials
|Query ID (link)
|2010 Collection: Featuring frame-based presentation and "live" dexter query forms|
||Illustrates extracting data from the detailed/base tables subcollection. This module is based on
3 video modules which deal with
i. Data organization and metadata needed to locate the table of interest
ii. The extraction itself.
iii. A postprocessing step (SAS program) that reads the extracted output and
completes the processing. It also illustrates merging margin-of-error data and calculating MOE's for derived measures.
||ustabs17_20 within acs2009/basetbls
||Shows how to use the text box in Sec. III to specify a list of variables to keep, overriding the
selection of a complete table.
||Extracts a set of key income measures for selected geographic levels for a specified state from the latest
(2008 vintage) ACS data.
|Using the parentheses to create a complex condition in Sec II;
Using the variable filter on the Numerics select list in Sec III;
using By and Id variables in Sec V-b;using Detailed metadata link and a key values report.
||Looks at population estimates (vintage 2009) for metropolitan statistical areas, and uses a Dexter/Rankster combo to generate a "Fifty Fastest Growing Metropolitan Areas in the U.S." report.
||How to select the rankster option and using that "cousin" application to generate a nicely formated ranks report.
|2007-2008 Collection: Older modules featuring datasets that sometimes no longer exist and
screen snapshots of the Dexter query forms.|
||Extracts a csv file with data for every state and county in the U.S. showing the Group Quarters population estimates for 7-1-2005. It also shows the values from the 2000 census. Total population and household population figures are also shown.
||Example of the very least you can do to get an extract.
||Accesses a standard extract data set for the 2000 census, Summary File 3, with state and county-level data for the whole country (including Puerto Rico). ... We keep 3 poverty count variables and the corrsponding percentages. Output is a plain text report file with custom title, subtitle and footnote.
||A 3-condition filter in Section II; Section IV is featured, with all 4 options filled in, including the sort; we use the "easy" option in Section 5 to get better column headers in the report.
||An example of accessing detailed ACS data (vintage 2006) that includes not only using uexplore and
dexter, but includes descriptions of pre- and post-processing. The pre-step involves using American FactFinder to locate the table(s) of interest. The (optional) post step shows a SAS program that manipulates the dexter extracted data to create a custom report using Proc Tabulate.
|| A routine 2-condition filter. There is a discussion of how to use the rarely used (but handy) "3rd way" to specify variables to keep in Section III - by typing in a variable list. There is a detailed discussion of postprocessing the data using SAS, including the simple steps needed to download the output SAS dataset for local processing.
||The 2005 American Community Survey tables are stored in data directory ("filetype") acs2005. ..In this example we assume that we want (to access ...) table B17002, containing data on poverty ratios of persons. We want to retrieve the data in a csv file (so that we can load it into Excel and do postprocessing) and we want it for all states ...
||Nothing beyond the basics. But we do explain how to get around a glitch (bug?) in the IE browser (Version 6) so that we are able to scroll through the Tables select list.
||The usccflows data set accessed by this query has rows that summarize movement of the population between U.S. counties using the decennial census. The tricky part of using this data set is to understand that we have two sides of every migration referred to as the "anchor" side and the "To/From" side. ...
||Advanced Report formatting Options: By variables for report; ID variables for report; and custom style used ("brick").
Also, option in Section I to pipe report directly to browser with no Output menu screen.
||We access a recent dataset in our population estimates collection, generating a report showing the latest population estimates for all counties in the Kansas City Metropolitan Statistical Area (2006 definition). We show the change in population since the 2000 census and the components of that change: natural increase (or decrease) and net migration (total and domestic).
||1) By variables and ID variables for a report (in Advanced Options section).
2) Changing the label of a variable to enhance readability of the report.
3) Requires user to use detailed metadata/Key Variables to look up metro area code for filter.
||We access a county-level estimates data set broken down by age, sex, race and hispanic origin. This is one of the more challenging modules, with a complex data filter (requiring lookup of code values in metadata). It also illustrates use of aggregation and specifying custom formats in the Advanced Options section. The output report generated here is at the state level and shows data for multiple summary types (demographic combinations). Intended to illustrate the power and flexibility of these data sets.
||1) Complex filter that uses Or logical operator and makes use of the parentheses check boxes to control order.
2) Uses the aggby box in Section V.
3) Uses other report formatting advanced features: specifying custom formats for variables containing codes, and
displaying on of the varibles as a byline.
4) Can be easily modified to work for any state. And for a later year, once data are available.