how to use group clause with new variable

[thanikondharish]

proc sql ;

select sex,case when sex='F' then age+5 else age+10 end as new_age from sashelp.class group by new_age;

quit;

how to calculate new_age sum group wise with in a program

[novinosrin]

how to calculate new_age sum group wise with in a program

sum of what within new_age

---

@thanikondharish wrote:

proc sql ;

select sex,case when sex='F' then age+5 else age+10 end as new_age from sashelp.class group by new_age;

quit;

how to calculate new_age sum group wise with in a program

---

[thanikondharish]

new_age group wise sum

[PGStats]

Your aggregated and aggregating variable is the same? Anyway... :

proc sql;
select 
    sex,
    case when sex='F' then age+5 else age+10 end as new_age,
    sum(calculated new_age) as sumAge 
from sashelp.class 
group by sex, calculated new_age;
quit;

[Kurt_Bremser]

Provide example data in a data step with datalines.