The GTILE Procedure

Example 2: Specifying the COLORRAMP= Option, and Setting the DETAILLEVEL= Option

Procedure features:

PROC GTILE statement

FLOW statement

COLORVAR=

COLORRAMP=

DETAILLEVEL=

Data Set:

SASHELP.ORSALES Subset

Sample Library Member:

GTLCOLOR

PROC GTILE generates this chart displaying a subset of the SASHELP.ORSALES data set. The FLOW statement defines the layout of the data. The size of each tile indicates the number of items sold. The color of each tile indicates the profit. The visualization of the data with the GTILE procedure makes it easy to see the data extremes for profit relative to the number of items sold.

Tile Chart of a Subset of SASHELP.ORSALES (gtlcolor)

[tile chart of sashelp.orsales]

Clicking on the "Skates" product_group subsets the "Skates" observations by year. The updated display provides information on the "Skates" profits by year.

Subset of SASHELP.ORSALES where Product_Group="Skates" (gtlcolor)

[click on assorted sports articles]

ods listing close;

ods html file="sport_sales.html";

goptions reset=all device=java;

data sports_only;
  set sashelp.orsales;
  if product_line="Sports";
  format profit dollar12.;
  format quantity comma12.;
run;

proc gtile data=sports_only;
    flow quantity tileby=(product_group year) /
        colorvar=profit
        /* display less details */
        detaillevel=1 
        /* reverse the colors so that blue is highest */
        colorramp=(CXDD6060 CXFFFFFF CX6497EB);
run;
quit;

ods html close;

ods listing;

Top of Page