how to roll up data to a higher level

[bunnycao]

   Hi all,

the data is as follows:

FAC  BOR     x

1          a       33

2          a       55

3           b      11

4           b       44

5           b       66

FAC is the unique ID, the goal is to roll up the data to BOR level, (ie. make BOR unique, with value x equal to the sum of all unique FAC belonging to the same BOR).

Thanks!

[RW9]

proc sql;

     create table WANT as

     select     BOR,

                    sum(X) as X

     from       HAVE

     group by BOR;

quit;

[dcruik]

To add another option to RW9's code would be the MEANS procedure.

proc means data=HAVE sum nway noprint;

var X;

class BOR;

output out=WANT (Drop=_TYPE_ _FREQ_)

sum=X;

run;

[bunnycao]

Thanks guys.