02-24-2017 09:18 AM - edited 02-24-2017 09:43 AM
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?
02-24-2017 09:31 AM
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;
02-24-2017 09:40 AM - edited 02-24-2017 09:42 AM
Thank you for your post, but I cannot use any form of data steps, procedures or statements in MIP. ONLY functions.