Date:         Tue, 9 Sep 2008 11:09:38 -0500
Reply-To:     "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Subject:      Re: Need Constant Number or Rows from PROC REPORT
Comments: To: Paul Bartells <paul.bartells@txu.com>
In-Reply-To:  <200809091543.m89AkfkJ018324@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Supplying actually usable data with partially working REPORT would be helpful.

I'm not sure I know exactly what you want but it sound like COMPLETEROWS....

Have you looked at that option?

COMPLETECOLS|NOCOMPLETECOLS
creates all possible combinations for the values of the across
variables even if one or more of the combinations do not occur within
the input data set. Consequently, the column headings are the same for
all logical pages of the report within a single BY group.

Default: COMPLETECOLS
Interaction: The PRELOADFMT option in the DEFINE statement ensures
that PROC REPORT uses all user-defined format ranges for the
combinations of across variables, even when a frequency is zero.

COMPLETEROWS|NOCOMPLETEROWS
displays all possible combinations of the values of the group
variables, even if one or more of the combinations do not occur in the
input data set. Consequently, the row headings are the same for all
logical pages of the report within a single BY group.

Default: NOCOMPLETEROWS
Interaction: The PRELOADFMT option in the DEFINE statement ensures
that PROC REPORT uses all user-defined format ranges for the
combinations of group variables, even when a frequency is zero.



On 9/9/08, Paul Bartells <paul.bartells@txu.com> wrote:
> Hey, Guys.  I am seeking suggestions on how to reach my objective, that
> being to create a summary report that has a fixed number of rows.  For
> example, I have two risk categories for which I generate unit counts and
> associated dollars.  There is no guarantee that all possible values of
> risk1 and risk2 will be on the dataset PROC REPORT is reading.  Risk1 has
> 9 possible values, risk2 has 6 for a total of 54 combinations.  The
> resultant matrix is being linked to an Excel workbook, so I need it to
> have the same number of rows always.  (FWIW, this report is created on a
> UNIX system using ODS HTML to generate a .XLS file which is then FTPd to a
> PC.)
>
> To illustrate:
>
> risk1       risk2
> -------     -------
> platinum    excellent
> gold        good
> silver      basic
> value       value
> basic       marginal
> high_1      high_risk
> high_2
> high_3
> high_4
>
> What I seek is a way to force 54 rows of output with the 6 values of risk2
> for each value of risk1.  Understanding that artificially forcing rows to
> appear can impact averages and counts, etc., what suggestions might you
> have?
>
> Many thanks.
>
> Paul Bartells
> TXU Energy
> Dallas, TX
>