| LAYOUT DATAPANEL Statement |
| 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. |
Default: The GraphBackground:Color style reference.
Interaction: OPAQUE=TRUE must be in effect for the color to be seen. By default, OPAQUE=FALSE.
Default: FALSE
Default: The GraphBorderLines style element.
Interaction: BORDER=TRUE must be set for this option to have any effect.
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.
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.
Requirement: Axis options must be enclosed in parentheses and separated by spaces.
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.
Default: 0
Tip: If there are n columns, then there are n -1 gutters.
Default:
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.
Default: The GraphHeaderBackground:Color style reference.
Interaction: HEADEROPAQUE=TRUE must be in effect for the color to be seen.
Default: The GraphValueText style element.
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
Default: TRUE
Interaction: When this option is set to FALSE, the background color for cell headers is not used.
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.
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.
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.
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. |
Default: FALSE
Default: LEFT
Interaction: This option is ignored unless AUTOALIGN=NONE.
Default: FALSE
Interaction: When OPAQUE=FALSE, the background color is not used.
Default: The GraphDataText style element.
Default: TOP
Interaction: This option is ignored unless AUTOALIGN=NONE.
Default: FALSE
Interaction: When this options is set to FALSE, the background color is not used.
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.
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.
Values without units are in pixels (px). A unit must be provided if other than pixels.
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.
Requirement: Axis options must be enclosed in parentheses and separated by spaces.
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.
Default: 0
Tip: If there are n rows, then there are n -1 gutters.
Default:
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.
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:

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

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).
Default: FALSE
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:

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

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 |
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.