ID statement in PROC SUMMARY

[Jaheuk]

dear all,
i am using a PROC SUMMARY to calculate the MAX value per year/week.
I also want to know in which week this max value occured so i tried to
use the ID statement.
But this does not work because the proc gives me the max week for the
specified group.
This is also stated in the sas help!!

How can i get my wanted info (without writing datasteps of course 😉


GreetZ,
Herman

[sbb]

Your CLASS or BY statement must also include some SAS variable(s) to identify the year/week (likely a week-start date). The ID statement is not for this purpose, I would say.

Scott Barry
SBBWorks, Inc.

[Paige]

If you want to know which week (out of the 52 weeks per year) has the maximum value per year (I hope I am understanding you properly), then try the MAXID option of the OUTPUT statement.