topic Re: how to roll up data to a higher level in SAS Procedures

how to roll up data to a higher level

bunnycao — Thu, 25 Jun 2015 14:27:03 GMT

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!

Re: how to roll up data to a higher level

RW9 — Thu, 25 Jun 2015 14:44:07 GMT

proc sql;

create table WANT as

select BOR,

sum(X) as X

from HAVE

group by BOR;

quit;

Re: how to roll up data to a higher level

dcruik — Thu, 25 Jun 2015 14:50:29 GMT

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;

Re: how to roll up data to a higher level

bunnycao — Thu, 25 Jun 2015 15:12:54 GMT

Thanks guys.