GTILE Procedure

FLOW, TILE, and TOGGLE Statement

Create a tile chart in one of the three display layouts.
Requirement: At least one numeric chart size variable and one TILEBY= variable is required.
Global statements: FOOTNOTE, GOPTIONS, TITLE
Supports: Drill-down functionality

Syntax

FLOW | TILE | TOGGLE size-variable TILEBY=(levels-variable) |
(levels-list) variable list delimiter can be either a blank space or a comma </option(s)>;

Summary of Optional Arguments

Appearance options
specifies the color to be assigned to tiles when the COLORVAR= value is missing.
specifies where the colors need to transition on the color ramp with respect to the normalized values of the color variable.
specifies the colors to be distributed continuously across the range of data values.
specifies whether a color ramp or discrete colors are used to color the tiles.
specifies a variable whose values determine the color of the tiles.
specifies the number of levels to display.
specifies the number that corresponds to the level of labels to display.
specifies the maximum endpoint value of a continuous legend range.
specifies the minimum endpoint value of a continuous legend range.
Catalog entry description options
specifies a description of the output.
specifies the name of any graphics output file created.
Midpoint options
specifies the midpoint value for the tiles.

Required Arguments

size-variable
specifies a numeric variable from the input data set. The values of this variable are used to determine the size of each tile. If the COLORVAR= option is not specified, then the size variable is used to assign a color to each tile.
TILEBY=(levels-variable)|( levels-variable-list)
specifies the variable, or a list of variables, that define the tile-segments and the chart levels. The variables can be character or numeric. Variable must be enclosed in parenthesis and you can use either commas or blank spaces as delimiters.

Optional Arguments

The options in a GTILE statement affect all chart levels. Specify as many options as you want and list them in any order.

BASELINE=midpoint
specifies the midpoint value for the tiles.
CDEFAULT=missing-value-color
specifies the color to be assigned to tiles when the COLORVAR= value is missing. The color used to identify missing values is represented by a missing color indicator to the right of the legend.
CDEFAULT=yellow
CDEFAULT=yellow
Alias:CDEF=
Restriction:Partially supported by ActiveX.
Interaction:This option is ignored when COLORTYPE=DISCRETE.
COLORPOINTS=(point-1 point-2 ... point-n)
specifies where the colors need to transition on the color ramp with respect to the normalized values of the color variable. The colors are specified by the COLORRAMP= option. A value must be provided for each color that is specified by the COLORRAMP= option. You can use a space or a comma to separate the values. Each transition point is specified as a percentage of the total range of the color ramp. For example, if COLORRAMP=(red green blue), COLORPOINTS=(0, 0.75 1), and the range of the color variable is 100, the color ramp begins with red at 0, transitions to green at 75, and then transitions to blue at 100. By default, the range is set to the range of the color variable. The range can be modified with the MAXLEGENDVALUE= and MINLEGENDVALUE= options.
Default:The color transition points are distributed equally along the color ramp.
Range:0 to 1
Requirements:The COLORRAMP= option must be specified before you can use the COLORPOINTS= option.

The number of values that are specified in the COLORPOINTS= option must exactly match the number of colors that are specified in the COLORRAMP= option.

Interactions:This option is ignored when COLORTYPE=DISCRETE.

The MAXLEGENDVALUE= and MINLEGENDVALUE= options modify the range of the color ramp.

MAXLEGENDVALUE=

MINLEGENDVALUE=

Specifying a Custom Range for the Color Ramp

COLORRAMP=(color-ramp color-list)
specifies the colors to be distributed continuously across the range of data values. The three-color gradient legend provides a key to the value of the colors plotted on the chart. The legend label is the variable used to color the tiles. The legend displays the variable's minimum value, the maximum value, and the midpoint value.
Note: When the COLORRAMP= option is used with the ACTIVEX device, the graph viewers cannot change the color ramp colors using the ActiveX Control Properties dialog box. In that case, the color gradient color pickers are disabled on the Tile tab.
Two colors are required to create a color ramp. However, the number of colors that can be provided is not limited. These values specify the minimum, and the maximum values of the color ramp. If only two colors are specified, the legend midpoint is not be labeled. The delimiter can be either blank spaces or commas. All of the color-naming schemes supported by SAS/GRAPH are valid.
COLORRAMP=(cxbcd3aa cxae9aeb)
Two color color-ramp
COLORRAMP=(cxbcd3aa cx5f8e97 cxae9aeb)
Three color color-ramp
Alias:RAMP=
Style reference:Color attribute of the ThreeColorRamp element
Interaction:This option is ignored when COLORTYPE=DISCRETE.
Note:When the COLORRAMP= option is used to specify custom colors and the ACTIVEX device is used to generate the chart, the chart users cannot change the chart’s gradient colors from the Tile tab of the ActiveX Control Properties dialog box. In that case, Color under Color gradient is disabled on the Tile tab.
COLORTYPE=CONTINUOUS | DISCRETE
specifies whether a color ramp or discrete colors are used to color the tiles. When COLORTYPE=CONTINUOUS, a color ramp is used to color the tiles. A continuous legend is used in that case to denote the tile colors. When COLORTYPE=DISCRETE, discrete colors are used to color the tiles. A discrete legend is used to denote the tile colors in that case.
Default:CONTINUOUS when COLORVAR= is not specified or when COLORVAR= specifies a numeric variable

DISCRETE when COLORVAR= specifies a character variable

Style references:GraphData1–GraphDataN (DISCRETE only), the color attribute of the ThreeColorRamp element (CONTINUOUS only)
Restrictions:The legend is always positioned at the bottom of the chart. Because the LEGEND statement is not supported, the legend cannot be relocated.

When COLORTYPE=DISCRETE, you must use the COLORS= graphics option to change the chart colors from the default GraphData1 through GraphDataN colors. See COLORS.

Interaction:When COLORTYPE=DISCRETE, the COLORPOINTS=, COLORRAMP=, DETAILLEVEL=, MINLEGENDVALUE=, and MAXLEGENDVALUE= options are ignored.
Note:When the COLORTYPE=DISCRETE option is used and the ACTIVEX or JAVA device is used to generate the chart, the chart users cannot change the chart’s gradient colors using the ActiveX Control or Java Applet pop-up menu. For the ActiveX Control, Colors and Center are disabled on the Tile tab on the Properties dialog box in that case. For the Java Applet, GradientEditor is disabled on the Data Options dialog box in that case.
COLORVAR=color-variable
specifies a variable whose values determine the color of the tiles. The variable can be character or numeric. The values of this variable are sorted in ascending order. The smallest value is assigned to the first color in the color ramp, and the largest value is assigned the last color in the color ramp. Each of the remaining values is assigned a color from the gradient list of colors between the first, and the last colors in the color ramp.
COLORVAR=cylinders
COLORVAR=cylinders
DESCRIPTION=“description
specifies a description of the output. The maximum length for description is 256 characters. The description does not appear in the output. The descriptive text is shown in each of the following:
  • the chart description for Web output (depending on the device driver that you are using). See Chart Descriptions for Web Presentations for more information.
  • the Table of Contents that is generated when you use CONTENTS= on an ODS HTML statement, assuming that the output is generated while the contents page is open.
  • the description and the properties for the output in the Results window.
  • the description and properties for the catalog entry in the Explorer.
  • the Description field of the PROC GREPLAY window.
The description can include the #BYLINE, #BYVAL, and #BYVAR substitution options, which work as they do when used on TITLE, FOOTNOTE, and NOTE statements. Refer to Substituting BY Line Values in a Text String. The 256-character limit applies before the substitution takes place for these options. Thus, if in the SAS program the description text exceeds 256 characters, it is truncated to 256 characters, and then the substitution is performed.
Alias:DES=
Default:Tile chart of tileby
Restriction:Partially supported by ActiveX and Java.
DETAILLEVEL=1-to-the-number-of-variables-specified-by-TILEBY=
specifies the number of levels to display. The valid values for the DETAILLEVEL= option are from one to the number of variables listed in the TILEBY= levels list. Each level has a unique outline. As you drill down through the levels, the second level lines are thinner in weight and lighter in color. As you drill down to the third and lower levels, the outlines are the same as the top level. The levels are listed above the chart on the left. The DETAILLEVEL= option does not affect the drill-down functionality.
DETAILLEVEL= Option Is Omitted
DETAILLEVEL= option omitted
If the DETAILLEVEL=1, only the first level of detail is initially displayed. Only the details of the current level are displayed at any given point in the navigation.
DETAILLEVEL=1
DETAILLEVEL=1
Alias:DLEVEL=
Default:3
Interaction:This option is ignored when COLORTYPE=DISCRETE.
LABELLEVEL=1-to-the-number-of-levels-variables-specified-by-TILEBY=
specifies the number that corresponds to the level of labels to display. The valid values for the LABELLEVEL= option are from one to the number of variables listed in the TILEBY=levels list. The levels are listed above the chart, on the left. The LABELLEVEL= option does not affect the drill-down functionality.
If the LABELLEVEL= option is omitted, level 1 labels are initially displayed.
LABELLEVEL= Option Is Not Used
LABELLEVEL= option omitted
If LABELLEVEL=3, the third level labels are displayed. Once you navigate past the LABELLEVEL specified, subsequent levels display their respective labels.
LABELLEVEL=3
LABELLEVEL=3
Alias:LLEVEL=
Default:1
MAXLEGENDVALUE=max-value
specifies the maximum endpoint value of a continuous legend range. By default, the maximum legend endpoint value is set to the highest data value. The MAXLEGENDVALUE= option overrides the default value. Tiles whose data value exceeds MAXLEGENDVALUE are colored gray.
Interaction:This option is ignored when COLORTYPE=DISCRETE.
MINLEGENDVALUE=min-value
specifies the minimum endpoint value of a continuous legend range. By default, the minimum legend endpoint value is set to the lowest data value. The MINLEGENDVALUE= option overrides the default value. Tiles whose data values are less than MINLEGENDVALUE are colored gray.
Interaction:This option is ignored when COLORTYPE=DISCRETE.
NAME=“entry”
specifies the name of any graphics output file created. The name can be up to 256 characters long. If the name duplicates an existing filename, SAS/GRAPH adds a number, or increments the last number used to create a unique graph name (for example, graph1.png).
Default:graph.png

Details

Description

The FLOW, TILE, and TOGGLE statements specify the type of layout, the variables that define the chart levels, and the tile sizes used to display the data. One of the following display layouts is required:
FLOW
creates a chart that honors data order and can be read from left to right.
TILE
creates a chart that orders data by value, descending from bottom left to top right.
TOGGLE
creates a chart that honors data order and can be read from left to right. When changing levels, the display toggles from one row to one column.