2 weeks ago
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;
Need further help from the community? Please ask a new question.