topic Re: max sum per group in SAS Programming

max sum per group

monday89 — Sat, 08 Feb 2020 00:58:56 GMT

Hi I have the following table:

What I would like to do is that: take max cumulativefrequency of the "group" and create a static column. Something like this

i tried to proc sql;

create table test c as

select group, max(CumulativeFrequency) as total

from have;

group by group;

quit;

it works but i have to rejoin test and have. is there a way without creating additional dataset?

novinosrin — Sat, 08 Feb 2020 01:16:41 GMT

Try chaging your SELECT clause to

select *, max(CumulativeFrequency) as total

That will auto-remerge as long as the select clause has a variabe read from input table that is not part of a by group

unison — Sat, 08 Feb 2020 02:29:44 GMT

Change:

proc sql;

create table test c as

select ~~group~~, max(CumulativeFrequency) as total

from have;

group by group;

quit;

To:

proc sql;
create table test as
select *, max(CumulativeFrequency) as total
from have
group by group;
quit;