Date:         Wed, 8 Jan 2003 23:55:15 -0500
Reply-To:     Ceasar <ocerda@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ceasar <ocerda@HOTMAIL.COM>
Subject:      grouping data

I have the following data that i would like to group as follows:

BHCID  BHCNAME  BHCASSET  BHCRATING SUBSIDIARYID SUBNAME  SUBASSET
1999   NABHC    1,590,940  2        1001         NABBK1   1,000
1999   NABHC    1,590,940  2        1002         NABBK2   2,000
1999   NABHC    1,590,940  2        1003         NABBK3     900
2999   BBBHC    2,499,940  3        2001         BBBBK1     400
2999   BBBHC    2,499,940  3        2002         BBBBK2   1,000
3999   AABHC    1,700,000  1        3003         AAABK3     100

(and so on.......)


GROUPED AS FOLLOWS

1999   NABHC    1,590,940  2
1001   NABBK1       1,000
1002   NABBK2       2,000
1003   NABBK3         900

2999   BBBHC    2,499,940  3
2001   BBBBK1         400
2002   BBBBK2       1,000

3999   AABHC    1,700,000  1
3003   AAABK3         100

(and so on........)


Is it possible to create a data set in this format? Or would one have to do
this in a 'report'?  I normally like to export my results into excel.

Any help would be great...

post or email to ocerda@hotmail.com