topic Re: How to sum and then find max in sql in SAS Studio

How to sum and then find max in sql

ydu180 — Tue, 01 Aug 2017 11:54:19 GMT

I need to sum the hits of each player and then show the max one. This is my code, but I has syntax problem on this nested sql, can someone help to figure out?

proc sql;
title2"Part 2d";
select distinct PlayerID, min(YearID) label="First Year", sum(H) as Total_Hits
   group by PlayerID
   where Total_Hits=max(Total_Hits);
quit;
title;

Re: How to sum and then find max in sql

RW9 — Tue, 01 Aug 2017 12:09:40 GMT

What nested SQL?

I can see off the bat that where should be having.

Re: How to sum and then find max in sql

Ksharp — Tue, 01 Aug 2017 12:14:08 GMT

proc sql;
select *
 from (
select sex,sum(height) as total
 from sashelp.class
  group by sex
)
   having  total=max( total);
quit;