topic Re: In search of a Base SAS function: SUM BY GROUP in SAS Programming

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

Elle — Fri, 24 Feb 2017 14:43:22 GMT

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?

Re: In search of a Base SAS function: SUM BY GROUP

Rick_SAS — Fri, 24 Feb 2017 14:31:40 GMT

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;

Re: In search of a Base SAS function: SUM BY GROUP

Elle — Fri, 24 Feb 2017 14:42:26 GMT

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