|
Mark,
Take a look at this paper: www.lexjansen.com/pharmasug/2004/technicaltechniques/tt02.pdfSimilar.
It discusses ODS RTF and Proc Report but his first example appears to do exactly what you are asking.
Good Luck,
Dennis
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Terjeson, Mark
Sent: Thursday, February 23, 2012 1:26 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Need help with row label
Hi All,
re: Need help with row label
Using the COLUMN statement, with string literal and parens, you can add an additional header label that spans over a couple of individual columns. e.g.
proc report data=sashelp.class;
column Name ('Attributes' Sex Age Height Weight); run;
will yield:
+---------+-----------------------------+
| | Attributes |
+---------+-----+-----+--------+--------+
| Name | Sex | Age | Height | Weight |
+---------+-----+-----+--------+--------+
My question: Is there a way in PROC REPORT or PROC TABULATE to add a label that spans rows instead?
e.g.
+---------+---------+-----+-----+
| | Name | Sex | Age |
+---------+---------+-----+-----+
| | Alice | F | 13 |
| +---------+-----+-----+
| Girls | Barbara | F | 13 |
| +---------+-----+-----+
| | Carol | F | 14 |
+---------+---------+-----+-----+
| | Alfred | M | 14 |
| +---------+-----+-----+
| Boys | Henry | M | 14 |
| +---------+-----+-----+
| | James | M | 12 |
+---------+---------+-----+-----+
Thanks for any ideas,
Mark Terjeson
Investment Business Intelligence
Investment Management & Research
Russell Investments
206-505-2367
Russell
Global Leaders in Multi-Manager Investing
The information contained in this message is intended only for the use of the recipient named above. This message may contain privileged, confidential or undisclosed information. If the reader of this message is not the intended recipient or an agent responsible for delivering to the intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution or copying of it is strictly prohibited. If you have received this message in error, please notify us by telephone immediately at (206) 505-2367. Thank you for your cooperation.
|