SAS Institute. The Power to Know

SAS/GRAPH(R) 9.2: Graph Template Language Reference

Previous | Next
LAYOUT DATAPANEL Statement

Options

Option Description
BACKGROUNDCOLOR Specifies the color of the layout background.
BORDER Specifies whether a border is drawn around the layout.
BORDERATTRS Specifies the properties of the border line.
CELLHEIGHTMIN Specifies the minimum height of a cell in the grid.
CELLWIDTHMIN Specifies the minimum width of a cell in the grid.
COLUMNAXISOPTS Specifies axis options for all columns.
COLUMNDATARANGE Specifies how the X-axes of instances of the graph-prototype are scaled.
COLUMNGUTTER Specifies the amount of empty space that is between the columns.
COLUMNS Specifies the number of columns in the layout.
HEADERBACKGROUNDCOLOR Specifies the background color of the cell headers.
HEADERLABELATTRS Specifies the text properties for the cell headers.
HEADERLABELDISPLAY Indicates whether the automatic cell header text includes variable name and value or just the value.
HEADEROPAQUE Specifies whether the background for the cell headers is opaque.
INSET Specifies what information is displayed in an inset.
INSETOPTS Specifies the location and appearance options for the inset information.
OPAQUE Specifies whether the layout background is opaque.
ORDER Specifies whether cells are populated by column priority or by row priority.
PAD Specifies the amount of extra space that is added inside the layout border.
PANELNUMBER Specifies the number of the panel to produce.
ROWAXISOPTS Specifies axis options for all rows.
ROWDATARANGE Specifies how the Y-axes of instances of the graph-prototype are scaled.
ROWGUTTER Specifies amount of empty space between the rows.
ROWS Specifies the number of rows in the layout.
SKIPEMPTYCELLS Specifies whether the external axes skip the empty cells in a partially filled grid.
SPARSE Specifies whether crossings of the class variables include only the crossing in the data or all possible crossings.
START Indicates whether to start populating the data cells from the top-left or bottom-left corner.

BACKGROUNDCOLOR=style-reference | color
specifies the color of the layout background.

Default: The GraphBackground:Color style reference.

style-reference
A reference in the form style-element:style-attribute . Only the style-attribute named COLOR is used.

Interaction: OPAQUE=TRUE must be in effect for the color to be seen. By default, OPAQUE=FALSE.

BORDER=boolean
specifies whether a border is drawn around the layout.

Default: FALSE

BORDERATTRS=style-element | style-element (line-options) | (line-options)
specifies the attributes of the border line around the layout. See "General Syntax for Attribute Options" for the syntax on using a style-element and "Line Options" for available line-options .

Default: The GraphBorderLines style element.

Interaction: BORDER=TRUE must be set for this option to have any effect.

CELLHEIGHTMIN=dimension
specifies the minimum height of a cell in the grid.

Default: 100px

Tip: Use this option in conjunction with the CELLWIDTHMIN= option to set the minimum cell size.

Tip: The overall size of the panel is constrained by the HEIGHT= and WIDTH= options on the ODS GRAPHICS statement. As the number of cells in the grid increases, the size of each cell decreases. At some point the cell becomes so small that a meaningful graph cannot be rendered. This option sets the minimum height threshold for all cells. If the actual cell height becomes smaller, no panel is drawn.

CELLWIDTHMIN=dimension
specifies the minimum width of a cell in the grid.

Default: 100px

Tip: Use this option in conjunction with the CELLHEIGHTMIN= option to set the minimum cell size.

Tip: The overall size of the panel is constrained by the HEIGHT= and WIDTH= options on the ODS GRAPHICS statement. As the number of cells in the grid increases, the size of each cell decreases. At some point the cell becomes so small that a meaningful graph cannot be rendered. This option sets the minimum width threshold for all cells. If the actual cell width becomes smaller, no panel is drawn.

COLUMNAXISOPTS=(axis-options)
specifies X-axis options for all columns. For a list of options, see Chapter 45, "Axis Options for LAYOUT DATALATTICE/DATAPANEL."

Requirement: Axis options must be enclosed in parentheses and separated by spaces.

COLUMNDATARANGE=UNIONALL | UNION
specifies how the X-axes of instances of the graph-prototype are scaled.

Default: UNIONALL

UNIONALL scales the X-axis data ranges across all layout columns and panels (when PANELNUMBER= is in effect).
UNION scales data ranges of X-axes separately for each column on a per-panel basis.

Tip: Use the COLUMNAXISOPTS= option to control shared axis features.

Tip: See the PANELNUMBER= option for a discussion of how to create multiple panels.

COLUMNGUTTER=dimension
specifies the amount of empty space that is between the columns.

Default: 0

Tip: If there are n columns, then there are n -1 gutters.

COLUMNS=integer
specifies the number of columns in the layout.

Default:


  • If this option is not specified and ROWS= is specified, the number of data cells (and columns) increases dynamically to allow all classifier values to be presented.
  • If both this option and ROWS= are specified, a grid of that size will be created, regardless of the number of classifier values. If the number of classifier values is greater than the grid size, no graphs will be created for some classifier values. If the number of classifier values is small and the grid size large, there may be empty cells created.

Interaction: The overall grid size is constrained the HEIGHT= and WIDTH= options on the ODS GRAPHICS statement. As the grid size grows, the cell size shrinks. To control the minimum size of a cell use the CELLHEIGHTMIN= and CELLWIDTHMIN= options.

Tip: The START= and ORDER= options affect the how the rows are populated.

Tip: The PANELNUMBER= option enables you to create multiple smaller grids that completely partition the classifier values.

HEADERBACKGROUNDCOLOR=style-reference | color
specifies the background color of the cell headers.

Default: The GraphHeaderBackground:Color style reference.

style-reference
A reference in the form style-element:style-attribute . Only the style-attribute named COLOR is used.

Interaction: HEADEROPAQUE=TRUE must be in effect for the color to be seen.

HEADERLABELATTRS=style-element | style-element (text-options) | (text-options)
specifies the color and font attributes of the data labels. See "General Syntax for Attribute Options" for the syntax on using a style-element and "Text Options" for available text-options .

Default: The GraphValueText style element.

HEADERLABELDISPLAY=NAMEVALUE | VALUE
indicates whether the automatic cell header text includes variable name and value or just the value.

Default: NAMEVALUE

Example: If the classification variables were Country and Product, HEADERLABEL=NAMEVALUE would produce cell headers such as

  
   Country=CANADA 
   Product=TABLE
 

and HEADERLABEL=VALUE would produce

  
   CANADA 
   TABLE
 

HEADEROPAQUE=boolean
specifies whether the background for cell headers is opaque (TRUE) or transparent (FALSE).

Default: TRUE

Interaction: When this option is set to FALSE, the background color for cell headers is not used.

INSET=(variable-list)
specifies what information is displayed in an inset. The variable-list defines one or more variables whose names and values appear as a small table in the data cells. The variables may be either numeric or character. Variable names are separated by spaces.

Default: no default

Tip: The location and appearance of the inset is controlled by the INSETOPTS= option.

Tip: The variable values are associated with the data cells by data order. That is, the first observation from all the variables in variable-list are used in the first data cell, the second observation from all variables in variable-list are used in the second data cell, and so on. If a value is missing for an observation, the corresponding name-value pair is skipped in the affected data cell. Note that the order of the data cells in the panel is affected by the CLASSVARS=, START=, and ORDER= options.

The data for the variable-list will most likely need preprocessing.

INSETOPTS=(appearance-options)
specifies location and appearance options for the inset information.

The appearance-options can be any one or more of the settings that follow. The options must be enclosed in parentheses, and each option is specified as a name = value pair.

AUTOALIGN=NONE | AUTO | (location-list)
specifies whether the inset is automatically aligned within the layout.

Default: NONE


NONE Do not automatically align this inset. This inset's position will be set by the HALIGN= and VALIGN= appearance-options .
AUTO Attempt to center this inset in the area that is farthest from any surrounding markers. Data cells may have different inset placements.
(location-list) Restrict this inset's possible locations to those locations in the specified location-list , and use the location-list position that least collides with the data cell's other graphics features. The location-list is blank-separated and can contain any of these locations: TOPLEFT TOP TOPRIGHT LEFT CENTER RIGHT BOTTOMLEFT BOTTOM BOTTOMRIGHT. Example: AUTOALIGN = (TOPRIGHT TOPLEFT)

Interaction: When AUTOALIGN=AUTO or (location-list ), the HALIGN= and VALIGN= appearance-options are ignored.

BACKGROUNDCOLOR= style-reference | color
specifies the color of the inset background

Default: The background is transparent. No color is assigned.

style-reference A reference of the form style-element : style-attribute . Only the style-attribute named COLOR is used.
BORDER= boolean
specifies whether a border is displayed around the inset.

Default: FALSE

HALIGN=LEFT | CENTER | RIGHT
specifies the horizontal alignment of the inset.

Default: LEFT

Interaction: This option is ignored unless AUTOALIGN=NONE.

OPAQUE= boolean
specifies whether the inset background is opaque (TRUE) or transparent (FALSE).

Default: FALSE

Interaction: When OPAQUE=FALSE, the background color is not used.

TEXTATTRS=style-element | style-element (text-options) | (text-options)
specifies the text properties of the entire inset. See "General Syntax for Attribute Options" for the syntax on using a style-element and "Text Options" for available text-options .

Default: The GraphDataText style element.

VALIGN=TOP | CENTER |BOTTOM
specifies the vertical alignment of the inset.

Default: TOP

Interaction: This option is ignored unless AUTOALIGN=NONE.

OPAQUE= boolean
specifies whether the layout background is opaque (TRUE) or transparent (FALSE).

Default: FALSE

Interaction: When this options is set to FALSE, the background color is not used.

ORDER=ROWMAJOR | COLUMNMAJOR
specifies whether data cells are populated by column priority or by row priority.

Default: ROWMAJOR

COLUMNMAJOR fills the data cells by columns, from the starting position.
ROWMAJOR fills the data cells by rows, from the starting position.

Interaction: The starting point for rendering data cells is controlled by the START= option. See the START= option for examples.

PAD=dimension | (pad-options)
specifies the amount of extra space that is added inside the layout border.

Default: The default padding for all sides is 0. Values without units are in pixels (px). A unit must be provided if other than pixels.

dimension
Specifies a dimension to use for the extra space at the left, right, top, and bottom of the layout border.
(pad-options)
Enables separate settings for the left, right, top, and bottom padding dimensions. Use the pad-options to create non-uniform padding. These options must be enclosed in parentheses. Each option is specified as a name = value pair. Sides not assigned padding are padded with the default amount.

Values without units are in pixels (px). A unit must be provided if other than pixels.

LEFT=dimension
specifies the amount of extra space added to the left side.
RIGHT=dimension
specifies the amount of extra space added to the right side.
TOP=dimension
specifies the amount of extra space added to the top.
BOTTOM=dimension
specifies the amount of extra space added to the bottom.

PANELNUMBER=positive-integer
specifies the number of the panel to produce.

Default: 1

Tip: This option enables you to partition a large grid into a number of smaller sized grids under these conditions:

1) You set a grid size explicitly (ROWS= and COLUMNS= options).

2) The grid size (gridrows x gridcolumns ) is smaller than the total number of classifier levels.

3) You execute the template N times and increment the panel number each time. N is determined by CEIL(total-classification-levels / gridrows x gridcolumns ).

Example: Suppose there are two classifiers (CLASS1 has 10 unique values and CLASS2 has 11 unique values). By setting some smaller grid size, say ROWS=3 and COLUMNS=4, and making the value of PANELNUMBER= a dynamic or macro variable, you can create 10 panels (9 panels with 12 data cells and 1 panel with 2 data cells) that collectively display all 110 possible crossings. You simply invoke PROC SGRENDER or a DATA step 10 times, incrementing the dynamic value for PANELNUMBER each time.

ROWAXISOPTS=(axis-options )
specifies Y-axis options for all rows. For a list of options, see Chapter 45, "Axis Options for LAYOUT DATALATTICE/DATAPANEL."

Requirement: Axis options must be enclosed in parentheses and separated by spaces.

ROWDATARANGE=UNIONALL | UNION
specifies how the Y-axes of instances of the graph-prototype are scaled.

Default: UNIONALL

UNIONALL scales the Y-axis data ranges across all layout rows and panels (when PANELNUMBER= is in effect).
UNION scales the Y-axis data ranges separately for each row in the layout.

Tip: Use the ROWAXISOPTS= option to control shared axis features.

Tip: See the PANELNUMBER= option for a discussion of how to create multiple panels.

ROWGUTTER=dimension
specifies the amount of empty space that is before the first row, between the rows, and after the last row.

Default: 0

Tip: If there are n rows, then there are n -1 gutters.

ROWS=integer
specifies the amount of empty space between the rows.

Default:


  • If this option is not specified and COLUMNS= is specified, the number of data cells (and rows) increases dynamically to allow all classifier values to be presented.
  • If both this option and COLUMNS= are specified, a grid of that size will be created, regardless of the number of classifier values. If the number of classifier values is greater than the grid size, no graphs will be created for some classifier values. If the number of classifier values is small and the grid size large, there may be empty cells created.

Interaction: The overall grid size is constrained the HEIGHT= and WIDTH= options on the ODS GRAPHICS statement. As the grid size grows, the cell size shrinks. To control the minimum size of a cell use the CELLHEIGHTMIN= and CELLWIDTHMIN= options.

Tip: The START= and ORDER= options affect the way the rows are populated.

Tip: The PANELNUMBER= option enables you to create multiple smaller grids that completely partition the classifier values.

SKIPEMPTYCELLS=boolean
specifies whether the external axes skip the empty cells in a partially filled grid.

Default: FALSE

FALSE External axes are displayed at their normal locations, even if there are empty cells at one or more of the locations.
TRUE External axes skip empty cells and "snap" to the nearest data cell, both vertically and horizontally. Though the empty cells are not displayed, the data cells in the grid are not enlarged to fill the area.

Discussion: Whenever the total number of classifier crossings (data cells) is not evenly divisible by the panel size (columns * rows), the last panel will be partially filled with data cells and padded with empty cells to complete the grid.

In this example, there are 16 data cells arranged in a 4-column, 3-row grid. This is default appearance of the last panel:


skip_false image


When SKIPEMPTYCELLS=TRUE, the empty padding cells of the last panel are removed and external axis ticks and tickvalues snap to the data cells:


skip_true image


Note that SKIPEMPTYCELLS=TRUE removes only the empty padding cells on the last panel and does not remove any data cells that have no crossing values and therefore no graph (these data cells are displayed when SPARSE=TRUE).

SPARSE=boolean
Specifies whether crossings of the class variables include only the crossings in the data or all possible crossings.

Default: FALSE

FALSE
Data cells are created only for crossings of the class variables that are in the data.
TRUE
The number of data cells is the product of the unique values for each classification variable.

Tip: By default, if a crossing of the class variables has a missing value as part of the data, a data cell is created for it.

Discussion: In this example, the classification variables are COUNTRY and STATE. There are 3 distinct values of COUNTRY (Canada, Mexico, and U.S.A.) Within Canada and Mexico there are 4 states, and within U.S.A. there are 8 states. All state names are unique to each country. Therefore, there are 16 unique STATE values and 48 unique crossings of COUNTRY and STATE, but there are data for only 16 of the crossings.

Assume a data panel layout is created with COLUMNS=6 and SPARSE=TRUE, meaning to display all possible crossings. This is what the first row would look like, with blank data cells being added whenever there are no data values for a crossing:


sparse_true image


When SPARSE=FALSE the crossings of the classifiers with no data are automatically removed. This compacts the display:


sparse_false image


START=TOPLEFT | BOTTOMLEFT
indicates whether to start populating the grid cells from the top-left or bottom-left corner.

Default: TOPLEFT

Interaction: If ORDER=ROWMAJOR (the default) and START=TOPLEFT (the default), a 2 row 2 column grid is populated as

cell 1 cell 2
cell 3 cell 4

If ORDER=ROWMAJOR (the default) and START=BOTTOMLEFT, a 2 row 2 column grid is populated as

cell 3 cell 4
cell 1 cell 2

If ORDER=COLUMNMAJOR and START=BOTTOMLEFT, a 2 row 2 column grid is populated as

cell 2 cell 4
cell 1 cell 3

If ORDER=COLUMNMAJOR and START=TOPLEFT, a 2 row 2 column grid is populated as

cell 1 cell 3
cell 2 cell 4
Previous | Next | Top of Page