SAS Data Table: Green Bar Model SCL

Reader Comments

This topic has downloads.

Updates

• 01/04/01 - Model SCL updated to handle compressed data sets and any data source that does not deliver an absolute row number. Prior to this update, the model scl would go into an infinite loop for data sources that did not provide an absolute row number. Only Version 8 model scl has been updated.
• 04/20/00 - Initial release

Warning

The Version 6.12 Model SCL will go into an infinite loop if used with a compressed data set.

What is green bar model scl?

The green bar model is a piece of compiled SCL code that is attached to a data table object, and is thus called by the data table model / viewer class. A picture is worth a thousand words.

Assume you have this program that creates a data set named levels:

data levels;
  do letter = 'A', 'B', 'E', 'C', 'D', 'G', 'F';
  do i = 1 to 5;
    do j = 1 to 5*ranuni(2);
	  x = ranuni(3);
	  output;
    end;
  end;
  end;
run;

This screen shot demonstrates when column i is selected to define the green bars. A change in the value of column i from one row to the next causes the background color to change to it's alternate. In mumbo jumbo it can be said to offer visualization of a state change in an unordered one level hierarchy. In data step jumbo, it visually differentiates each notsorted by-group. Future work could include multi-level hierarchies, different coloration for different amounts of hierarchical value state change and collapsable levels (a sub-domain of tabulate and multi-dimensional data bases.)

How does it work ?

For now that doesn't matter, feel free to use greenbar to make your life easier. Greenbar is not recommended for data sets with > 75,000 rows or more than several thousand expected 'bands'. The bands may be incorrect if a where clause is active.

Installation

This model scl is designed to be installed as common.model.greenbar.scl. However, greenbar should work regardless of catalog or catalog entryname it is stored in. If you want to experiment with greenbar first, try installing to the WORK library.

SAS Users: How do I use greenbar with viewtable ?

After the greenbar SCL is installed in a catalog, you should test if it works on your system. Open a table (submit the sample code above the screen shot if you don't have a table handy) using viewtable and issue the modelSCL command:

viewtable WORK.LEVELS
modelscl WORK.MODEL.GREENBAR.SCL

I also programmed my Ctrl-M key to issue this command:

modelSCL clear; modelSCL COMMON.MODEL.GREENBAR.SCL

Now, I am only one keystroke away from using greenbar.

SAS/AF Programmers: How do I use greenbar with the Data Table class ?

After the greenbar SCL is installed in a catalog, you can attach the SCL entry to a data table object. In a frame, make a data table object, and in the object properties enter COMMON.MODEL.GREENBAR in the SCL Entry: field.

You can attach the model scl at run-time using the _setSource method.

OBJ1._setSource('COMMON.MODEL.GREENBAR.SCL');