DATA Step, Macro, Functions and more

Nested aggregate function

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Nested aggregate function

DATA TEST;
INPUT CUST A B C;
CARDS;
1 12 13 14
1 12 13 11
2 12 10 14
2 12 17 14
3 10 16 11
3 10 13 14
4 12 11 14
4 12 11 14
;
RUN;

 

GETTING ERROR: SUMMARY FUNCTIONS NESTED IN THIS WAY ARE NOT SUPPORTED

 

proc sql;
create table anal1 as
select cust
,SUM(sum(A,B,C)) AS TOT_ABC
,sum(A/calculated TOT_ABC) as A_tot_abc
,sum(B/calculated TOT_ABC) as B_tot_abc
,sum(C/calculated TOT_ABC) as C_tot_abc
from test
group by cust
;quit;


Accepted Solutions
Solution
‎09-01-2016 09:17 AM
Respected Advisor
Posts: 3,124

Re: Nested aggregate function

Yeah, syntax seems off a little bit, try below:

 

proc sql;
create table anal1 as
select cust
,SUM(sum(A,B,C)) AS TOT_ABC
,sum(A)/calculated TOT_ABC as A_tot_abc
,sum(B)/calculated TOT_ABC as B_tot_abc
,sum(C)/calculated TOT_ABC as C_tot_abc
from test
group by cust
;quit;

View solution in original post


All Replies
Solution
‎09-01-2016 09:17 AM
Respected Advisor
Posts: 3,124

Re: Nested aggregate function

Yeah, syntax seems off a little bit, try below:

 

proc sql;
create table anal1 as
select cust
,SUM(sum(A,B,C)) AS TOT_ABC
,sum(A)/calculated TOT_ABC as A_tot_abc
,sum(B)/calculated TOT_ABC as B_tot_abc
,sum(C)/calculated TOT_ABC as C_tot_abc
from test
group by cust
;quit;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 192 views
  • 0 likes
  • 2 in conversation