SAS 论文
Data Tables: Highlighting Techniques
Christopher A. Roper, Qualex Consulting Services, Inc.
Abstract
Data tables are arguably one of the best lookingwidgets in SAS®. This makes them a popularchoice for replacing the venerable Extended Tablewidget as a selection list, or front end to a data set.The model/viewer paradigm is an extremelyflexible tool that gives the Data Table, and it’sparent class the Table Editor, an extensive utilityacross a broad range of applications. Combinedwith the abundance of methods available to theData Table class, this widget can add a very nicetouch of polish to an application, giving it theprofessional, finished appearance a client demandsand deserves. This paper will illustrate fivescenarios for using highlighting to make the DataTable object more attractive and functional foryour information consumers.Introduction
Highlighting rows, columns, or individual cells ina Data Table is a powerful method to emphasizeimportant information, or remind the end-user ofprevious selections. There are two general inputtriggers available to signify when highlightingshould occur. The first is a data driven trigger,some predetermined value of a variable that willcause highlighting to occur when it is observed.Data driven highlighting may be column based orrow based. The other trigger is a user initiatedevent, such as the selecting of a cell. Userinitiated highlighting may be column base, rowbased, or cell based. This paper will presenttechniques that will accomplish each of these fivehighlighting tasks to illustrate how highlightingcan be used in the Data Table widget to make anapplication easier to use and more visuallyimpressive.
The Default Attributes
In order to make the examples as simple aspossible and enhance portability, each techniqueillustrated will use the following as defaults. Thedata set will be “SASHELP.IAWFIN”. The frameentry will reside in a catalog namedDATATBL.HIGHLITE, and will contain onewidget, named “TABLE”, which is an instance of
Data Table class with all of the object attributes leftto the original default settings, with the exception ofthe model’s SCL entry. For some examples, themodel’s SCL entry will be used to accomplish thehighlighting, and therefore each of those exampleswill have a different SCL entry for the table’s model.Highlighting is defined as the controlling of thebackground color of cells to make them standoutfrom the other cells of the table. The foregroundcolor of the cells may also be changed, to keep thetext in contrast with the background.Data Driven Highlighting
Data driven highlighting is the controlling of thebackground color of table cells based on the value ofa cell. Since the Data Table class may have only twodimensions, i.e. a row dimension and a columndimension, this section will provide a technique forhighlighting the individual cells of a column, and atechnique for highlighting the individual cells of arow.
Highlighting A Column Dimension
Highlighting the individual cells of a columndimension is the simplest of the highlighting tasks toaccomplish. For this illustration, the values of thevariable VARIANCE from the date setSASHELP.IAWFIN, will be highlighted accordingto the table below.Table 1



With the advent of version 6.12 came a new methodto make controlling the appearance of data tablesmuch easier to do. The_SET_VIEWER_ATTRIBUTE_ method wasdesigned for just this purpose. Entering the name ofan SCL entry in the SCL ENTRY field of the datatable widget’s object attributes, creates the model’sSCL entry. This entry may be edited just as anyother SCL entry, or by selecting the TABLE,EDIT
Highlighting_专业资料。? Scale- Many data sets are too large to visualize ...Apply fisheye techniques to 2D graph ? Experiment with a variety of ...
? 2013年8月14日星期三 Data Mining: Concepts and Techniques 12 From Tables and Spreadsheets to Data Cubes ? A data warehouse is based on a ...
Answer: TRUE Diff: 1 Page Ref: 362 14) Highlighting techniques can be ...367 32) Tables are very beneficial for analyzing data changes over time. ...
(virtual tables, CyberSphere, projection walls, ...2 Problem highlighting VR techniques require signi?...VR systems use a di?erent data?ow for ...
– Define general data management concepts and terms, highlighting the ...dimensional tables, called relations, that are the logical equivalent of ...
Imported data files can include: DBMS tables PC files Spreadsheets Delimited ...Starting SAS is done by clicking on the Start menu and highlighting the Pro...
/design and apply appropriate methods/techniques. ...tables, charts, and models, as well as concise...highlighting areas where further information or ...
On your machine — Graphs, Charts, Tables, ...Highlighting button; data flow is animated using ...44 Debugging Techniques Step Into, Over, and Out...
Skills of Highlighting. ? 强调的技巧 ? Adjust ...Tables & labels 10 for writing 11-12 for ...Special Composing Techniques General Composing ...
Datafiles & Segments Logfiles Tables, Constraints ...no room for discussing concepts and techniques. If...highlighting than blue but I did not scan the ...
热门文档