Date:         Thu, 1 Sep 2005 11:18:38 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: FIRST dot Processing
Comments: To: Carol Srna <csrna@FORD.COM>

Carol,

If I understand the problem correctly, then something like the following
SQL solution would be easist.  You could also do it through a combination
of sorting, proc summary, and a data step:

proc sql;
 create table desired as
  select distinct dataset_name,
       sum(Blksize*Blkcount) as SumBytes,
       calculated SumBytes/1024**3 as GBs
   from inputdata
    group by dataset_name
;
quit;

Art
---------
On Thu, 1 Sep 2005 10:42:01 -0400, Srna, Carol (C.) <csrna@FORD.COM> wrote:

>Sorry about that.
>See scenario below.
>
>
>> From:         Srna, Carol (C.)
>> Sent: Thursday, September 01, 2005 10:35 AM
>> To:   'SAS-L@LISTSERV.UGA.EDU'
>> Subject:      FIRST dot Processing
>>
>> Morning All.
>>
>> This is what I have.
>>
>> A number of datasets, some of them with the same name:
>>
>> DATASET NAME                                        Blksize
>> Blkcount
>AFOPER.IRM.BACKUP.G0001V00                        0000000000   000000772
>CAITBIL.TERADATA.ITBARC.NOV0904                0000031720   000004353
>CAITBIL.TERADATA.ITBARC.NOV0904                0000031720   000004359
>CAITBIL.TERADATA.ITBARC.NOV0904                0000031720   000004263
>>
>>
>If the dataset has the same name I only want one occurrence of the name,
>BUT I want the total of the # of Gbs for that name.
>
>Bytes=BLKSIZE*BLKCNT;
>GBs=Bytes/1024/1024/1024;
>
>I've got the FIRST. Processing started, but my calculations are wrong.
>
>Any help is appreciated.
>TIA