Dexter data extracter
Dexter -- Data Extracter
Dexter Quick Start Guide
Section headers are links to the relevant sections of online help.

Data Set:  /pub/data/acs2015   -   :   7845 rows/observations, 1074 columns/variables
See detailed metadata for this dataset.

(Optionally) Enter comments regarding this Dexter query:
(Hide Comments text box)

(Display Comments text box)

I. Choose Output Format(s)

Check here if requesting only a report in plain text or html format that you want piped directly to your browser.

II. Choose rows (observations) to keep by specifying a filter.

Variable/Column Operator Value
( )
And Or And Not
( )
And Or And Not
( )
And Or And Not
( )
And Or And Not
( )

In addition, you can limit the # of observations/rows on each output by entering a number here:

View qmeta Metadata report:   All Variables   -or-   ID Variables only

III. Choose columns (variables)

Check this box if you wish to keep ALL columns.
OR, select columns from the lists below. (hold down the CTRL key to get multiple selects.)

Identifiers Numerics

Filter by regular expression:


OR, there is a 3rd way (rarely used) to specify your variables - by typing your own variable list here:

IV. Other Options, Non-essential

Title: If you would like to specify a custom title to appear on your Listing/Report output you can do so here:

Subtitle: An optional smaller title to appear below the main title, specified above.

Footnote: Optional text to appear at the bottom of the report (html) or at the bottom of each page of the report (pdf/plain text). Replaces default.

Sort: Enter names of columns/variables by which you would like to sort the output.

V. Advanced Options

a. Specs for Aggregating the Selected Data

Agg Level:
Grand Totals?
Means or Percents:
Weights for Means/Pcts:
Variables to drop:
Drop redundant higher level summaries.
b. Advanced Report Formatting Options
Use variable labels as column headers in reports.
By variables for report (sort required):
ID variables for report:
Orientation of print output (only affects pdf):
Style to use for html or pdf ouptut:
c. SAS Variable Attribute Statements
You can specify variable formats, rename variables and/or specify new labels for variables. Rarely needed.
Format ;
Rename ;
Label ; (Use single quotes - NO double quotes)
d. Transpose Output
Check to indicate the output is to be transposed:
By variables (transpose within by groups formed by these variables):
Name variables on output using a prefix of: & appending the value of the variable
Assign labels to the output variables equal to the value of the variable
e. Coordinates of specified point (distance calculations and filtering).
Used to calculate _distance variable (ignored if data set has no intptlat, intptlon variables or geographic keys to do lookup):
Enter point coordinates:    Latitude:  and  Longitude:
  Note: a 5-digit U.S. ZCTA/ZIP code can be entered instead of a latitude value in which case the centroid coordinates of that ZIP/ZCTA will be used.
Check here to keep _distance pseudo-variable and any looked-up lat-long coordinates on output.
Check here to keep observations if _distance cannot be determined because lat-long coordinates are missing &/or cannot be looked up.

Rankster option:   -or-  skip dexter and go straight to rankster


Internal use only (_debug opt.)       Use test version of the application       Use GET method instead of POST method

Questions and comments regarding Dexter should be sent via e-mail to John Blodgett.
When reporting a problem, please specify the Job ID, listed at the top of the initial Dexter output page.

MCDC Home  ||  OSEDA Home  ||  Uexplore/Dexter tutorials  ||  Uexplore Home

Generated by the uex2dex application, revised 9/22/2014 8:19:20 AM

This request took 0.39 seconds of real time (v9.2 build 1495).