LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2012, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 23 Feb 2012 18:34:42 +0000
Reply-To:   "Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR)" <wfu4@CDC.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Schmid, Dennis (CDC/OSELS/SEPDPO) (CTR)" <wfu4@CDC.GOV>
Subject:   Re: Need help with row label
Comments:   To: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
In-Reply-To:   <0F548D585A011E4484D77C7B095EC53F1A678986@TAC-CMS001.prod.ds.russell.com>
Content-Type:   text/plain; charset="us-ascii"

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.


Back to: Top of message | Previous page | Main SAS-L page