X Samples: Dexter Queries With Detailed Descriptions

Index to the xsamples Mini-tutorials
Query ID (link) Summary Filetype Data Set Dexter Features
2010 Collection: Featuring frame-based presentation and "live" dexter query forms
acsBasetbls 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.
acs2009 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.
acsIncomeMeasures Extracts a set of key income measures for selected geographic levels for a specified state from the latest (2008 vintage) ACS data. acs2008 usmcdcprofiles3yr
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.
rankmetros 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. popests uscomcbsas09 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.
usgqpops05 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. popests usgqhhpops05 Example of the very least you can do to get an extract.
PoorestCounties 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. sf32000x usstcnty 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.
acsbasetabs1 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. acs2006 ustabs17_20 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.
acsbtable1 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 ... acs2005 btables2 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.
mig2000onecnty 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. ... mig2000 usccflows 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.
popcom1 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). popests uscom06 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.
casrh05 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. popests mocasrh05 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.