Date:         Fri, 9 Sep 2005 12:45:21 -0700
Reply-To:     Toby <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Toby <tobydunn@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: proc report ODS groupings
Comments: To: sas-l@uga.edu
In-Reply-To:  <1126293780.573550.121680@g43g2000cwa.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Greg,

consider :

ods listing close ;
ods pdf ;
proc report
 data = sashelp.class nowd ;
 by Age notsorted ;
 column Age Name Height Sex Weight ;
 define Age / Group ;
 Define Name / group style={foreground=red};
 run ;
ods pdf close ;
ods listing ;

Toby Dunn


If I wanted to put cndtlet and contid in a header at the top of each
page how would I do this in proc report and If I wanted to use item
with description and Units to be shaded a color in the
page for each item can this be done using proc report and ods?
and if so how?


thanks in advance,
Greg


ods pdf file = 'bid.pdf' style=sasweb;
options pageno=1 linesize=75 pagesize=45;
proc report data=final nowd;
column cndtlet contid item vnames btuprice btextamt idescr btoqty
iunits;
define cndtlet / group 'Letting';
define contid / group 'Contract';
define item / group 'Item';
define vnames / display 'Vendor';
define btuprice / display 'Unit Price';
define btextamt / display 'Bid Amount';
define idescr / display 'Description';
define btoqty / display 'Quantity';
define iunits / display 'Units';
break after cndtlet / skip;
break after contid / skip;
break after item / skip;
title 'Unbalance Bid Report';
run;
ods pdf close;
ods listing;


Reply