topic Re: how to use group clause with new variable in SAS Programming

how to use group clause with new variable

thanikondharish — Sun, 25 Nov 2018 05:05:37 GMT

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

Re: how to use group clause with new variable

novinosrin — Sun, 25 Nov 2018 05:13:52 GMT

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

Re: how to use group clause with new variable

PGStats — Sun, 25 Nov 2018 05:24:16 GMT

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;

Re: how to use group clause with new variable

thanikondharish — Sun, 25 Nov 2018 05:25:42 GMT

new_age group wise sum

Re: how to use group clause with new variable

Kurt_Bremser — Sun, 25 Nov 2018 07:23:06 GMT

Provide example data in a data step with datalines.