| 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 ? |
|
| 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]
|