!!!!This page has been copied, pasted and edited to become part of the dexterOnlineHelp.shtml page. This page is obsolete and should not be edited =============================================================== Dexter Advanced Options Help
Dexter Advanced Options Help Page

Part a: Aggregating the Data

You may find occasion where the data stored in one of the archive datasets is really more detailed than what you really need. It may have too many rows; you would prefer to collapse across rows to get numeric data summarized by aggregating (summing) the variables in rows that share a set of common identifier, or aggby variables. For example, let's say you are accessing one of the recent population estimates datasets where each row / observation had data for a county. Let's say that the dataset contains a variable named CBSA that has the code for the current (core based) statistical area (Metroplolitan or Micropolitan Statistical Area) associated with the county. Let's further suppose that what you really want is not the county populations but instead the CBSA figures. So you want to aggregate the data by CBSA, or perhaps by CBSA-within-state, so that you could get the Kansas portion of the KC MSA and the Missouri portion. Here is how you could do that:

Part b: Advanced Report Formatting Options

These options only make a difference if you chose something other than None in Part I from the Listing/Report format options on the 2nd line. These options have to do with various cosmetic and formatting features that only pertain to data in a report format.

Part c: SAS Variable Attributes

The general rule is that you don't have to know SAS to use Dexter. But this is one section where knowing the language could come in handy. Here we allow you to type in the body of 3 different SAS statements that are used to modify attributes (names, labels and formats) of any of the variables you have selected. The syntax of these statements is simple enough that even if you have never coded a SAS statement and hope to never have to you should not have too much difficulty using these statements.
Questions and comments regarding this help page or Dexter in general should be addressed to Glenn Rice

MCDC Home  ||  OSEDA Home  ||  Dexter tutorial: ppt format | html format  ||  Uexplore Home