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
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:
create table desired as
select distinct dataset_name,
sum(Blksize*Blkcount) as SumBytes,
calculated SumBytes/1024**3 as GBs
group by dataset_name
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
>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.
>I've got the FIRST. Processing started, but my calculations are wrong.
>Any help is appreciated.