In search of a Base SAS function that does a SUM BY GROUP

[Elle]

Hello,

I'm using SAS Model Implementation Platform and need to integrate some Base SAS code in order to do some calculations.

I would like to know if there's a function equivalent for this:

proc sql;
   select SUM(subaccount_EAD) as account_EAD
   from table
   group by account_number;
quit;

My variables are: account_number, subaccount_number and subaccount_EAD.

I'm looking for a function like: sumby.account_number(subaccount_EAD) if such a thing even exists.

I cannot use data steps or proc sql in MIP.

So, ... help?

[Rick_SAS]

if you sort the data by the grouping variable, you can use BY group processing in the DATA step:

proc sort data=sashelp.class out=Class;
by sex;
run;

data Want;
set Class;
by Sex;
if first.Sex then sum=0;
sum + height;
if last.Sex then output;
keep Sex Sum;
run;

proc print;run;

[Elle]

Thank you for your post, but I cannot use any form of data steps, procedures or statements in MIP. ONLY functions.