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 (August 2001, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 2 Aug 2001 11:04:35 -0700
Reply-To:   "Huang, Ya" <ya.huang@AGOURON.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Huang, Ya" <ya.huang@AGOURON.COM>
Subject:   Re: ODS question: Is rowspan possible ?
Comments:   To: Richard DeVenezia <radevenz@IX.NETCOM.COM>
Content-Type:   multipart/alternative;

This may not be what you want, but have you ever considered using proc tabulate? we can create a dummy var whose value is always=., then use tabulate to mimic report, something like:

data xx; do i=1 to 2; do j=1 to 5; x=repeat('x',ranuni(0)*30); dummy=.; output; end; end;

ods html file='c:\temp\temp.html';

options missing=''; proc tabulate; class i j x; var dummy; table i*j*x,dummy=[label='' style=[cellwidth=0]]*sum=''; run;

ods html close;

This way, we can almost make the tabulate output looks like a report output, thanks for ODS we don't have to get an evenly widened class var columns. The little thing that make me uncomfortable is that we always get an extra column for the analysis var dummy, even after I tried to limit its width to 0. If we can find a way to get rid of this extra column .....?

Regards,

Ya Huang

> -----Original Message----- > From: Richard DeVenezia [mailto:radevenz@IX.NETCOM.COM] > Sent: Wednesday, August 01, 2001 2:07 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: ODS question: Is rowspan possible ? > > > Does anyone know if there is a way to force Proc REPORT to rowspan the > columns defined as group or order ? > By default the group or order variable values appear on the > row where the > values first change. > Example: > Suppose an order variable COMPANY having value WIDGETCO > belongs to six rows. > Instead of six cells, with WIDGETCO in the topmost, I would > prefer a single > cell that is valign=middle and rowspans all six rows. > > -- > Richard DeVenezia >


[text/html]


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