Help using Base SAS procedures

how to roll up data to a higher level

Reply
Occasional Contributor
Posts: 8

how to roll up data to a higher level

   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!

Super User
Super User
Posts: 7,413

Re: how to roll up data to a higher level

proc sql;

     create table WANT as

     select     BOR,

                    sum(X) as X

     from       HAVE

     group by BOR;

quit;

Frequent Contributor
Posts: 130

Re: how to roll up data to a higher level

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;

Occasional Contributor
Posts: 8

Re: how to roll up data to a higher level

Thanks guys.

Ask a Question
Discussion stats
  • 3 replies
  • 680 views
  • 0 likes
  • 3 in conversation