| Date: | Wed, 5 May 2004 08:49:45 -0400 |
| Reply-To: | "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM> |
| Subject: | Re: Proc Template - bolding first column of output! |
|---|
Robert Walls wrote:
> Hi all,
>
> I have a slight problem. I am trying to create a proc template which
> will create output with the first column coming out as Bold, but no
> others. The only problem is that the naming of the first column is
> rarely going to be standard, so I would like the template to work,
> regardless of the name of the first column. I know that this can all
> be
> done using style statements in Proc Report etc, but would ideally
> prefer
> it to be done automatically in the template!
>
> Thanks all,
>
> Rob.
>
Proc TEMPLATE docs are dubiously helpful in many situations.
In version 9.1, there is a documented automatic variable _VAL_ found on the
Online Help page.
"
Use _VAL_ to represent the value of the current column. You may also
reference symbols that you declared in a DYNAMIC, MVAR, or NMVAR statement
in the definition.
"
More interestingly and applicable to you, there is an online help page
"TEMPLATE Procedure: Creating Tabular Output
Example 6: Setting the Style Element for a Specific Column, Row, and Cell
"
The example this use of undocumented _row_ and _col_ symbols:
"
proc template;
define table Checkerboard;
cellstyle mod(_row_,2) && mod(_col_,2) as data{background=magenta},
not(mod(_row_,2)) && not(mod(_col_,2)) as
data{background=magenta},
1 as data;
"
I found no other template related help that mentions _row_ or _col_.
I am presuming v8 template understands _val_, _row_ and _col_.
--
Richard A. DeVenezia
http://www.devenezia.com/downloads/sas/samples
|