topic Re: ID statement in PROC SUMMARY in SAS Procedures

ID statement in PROC SUMMARY

Jaheuk — Tue, 17 Feb 2009 11:07:59 GMT

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

Re: ID statement in PROC SUMMARY

sbb — Tue, 17 Feb 2009 13:19:17 GMT

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.

Re: ID statement in PROC SUMMARY

Paige — Tue, 17 Feb 2009 14:16:58 GMT

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.