Date:         Wed, 5 Mar 2008 17:03:28 -0500
Reply-To:     Hari Nath <hari_s_nath@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Hari Nath <hari_s_nath@YAHOO.COM>
Subject:      Re: Proc Report summarizing date observations

Lizette,

I did not run with test data....but can you try specifing the display
option in your date fields......think it may help...

--hari


On Wed, 5 Mar 2008 16:36:59 -0500, Lizette Koehler
<starsoul@MINDSPRING.COM> wrote:

>I have written a simple Proc Report to summarize one column only.
However it looks like it is trying to summarize the date fields.  Can
someone point me to what I am doing wrong?  I do not need the Proc Report
to do anything with the date fields.  I only want the TRKS field totaled.
And yes, some of the date fields are missing which is okay.
>
>
>This is under z/OS V1.7 with SAS V9.1.3
>
>Lizette
>
>
> proc report data=no_dsorg headline headskip;
>    column NODE1 dcddsnam  dcddsser  dcdmgtcl  trks dcdcredt
>           dcdlstrf       ;
>    define NODE1   / "HLQ" group format=$Char8.  ;
>    define dcddsnam/ "Data Set Name"
>                     format=$Char44. ;
>    define dcddsser/ "VolSer"  format=$Char6.  ;
>    define dcdmgtcl/ "Mgt Class"
>                     format=$Char8.  ;
>    define trks    / "Total Space used (TRKS) "
>                   analysis sum  format=6.0     ;
>    define dcdcredt/"Creation Date " format=date. ;
>    define dcdlstrf/"Last Ref Date " format=date.    ;
>    define Total / "Total Trks" computed format=15.0 ;
>
>     compute total ;
>     total = sum(Trks) ;
>     endcomp ;
>
>     Break after NODE1     / ol summarize skip ul ;
>    RBreak after           / ol summarize skip ul ;
>
>
>
>
>
>
>This is what a section of the report looks like.
>
>
MGT       TRKS  Create  Last Used
>HLQ       DATA SET NAME                                 VOLSER
CLASS      USED    Date    DATE
>
>
> ACI       ACI.PROD.A001                                 PROD07
STANDARD     2  26OCT01  15MAR04
> --------
                                                                  ----  ---
----  -------
>
ACI
  2  26OCT01  15MAR04
> --------
                                                                  ----  ---
----  -------
>
> SYS08055  SYS08055.T000657.RA000.ENF.R0500008
TEMP07             300  24FEB08     .
>           SYS08055.T000657.RA000.ENF.R0500009
TEMP18             300  24FEB08     .
>           SYS08055.T000804.RA000.CWVIEWS4.R0500030
TEMP12               1  24FEB08     .
>           SYS08055.T000804.RA000.CWVIEWS4.R0500031
TEMP06               1  24FEB08     .
>           SYS08055.T000804.RA000.CWVIEWS4.R0500032
TEMP05               1  24FEB08     .
>           SYS08055.T000804.RA000.CWVIEWS4.R0500033
TEMP03               1  24FEB08     .
>           SYS08055.T000805.RA000.CWVIEWS4.R0500034
TEMP15               1  24FEB08     .
>           SYS08055.T004943.RA000.ENF.R0400014
TEMP06             300  24FEB08     .
>           SYS08055.T004943.RA000.ENF.R0400016
TEMP18             300  24FEB08     .
>           SYS08055.T005009.RA000.CWVIEWS1.R0400031
TEMP07               1  24FEB08     .
>           SYS08055.T005009.RA000.CWVIEWS1.R0400032
TEMP03               1  24FEB08     .
>           SYS08055.T005009.RA000.CWVIEWS1.R0400033
TEMP10               1  24FEB08     .
>           SYS08055.T005009.RA000.CWVIEWS1.R0400034
TEMP08               1  24FEB08     .
>           SYS08055.T005010.RA000.CWVIEWS1.R0400035
TEMP18               1  24FEB08     .
> --------
                                                                  ----  ---
----  -------
>
SYS08055
1210  31JAN34     .
> --------
                                                                  ----  ---
----  -------