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!
proc sql;
create table WANT as
select BOR,
sum(X) as X
from HAVE
group by BOR;
quit;
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;
Thanks guys.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.