```Date: Mon, 10 Aug 2009 12:37:42 -0400 Reply-To: Nathaniel Wooding Sender: "SAS(r) Discussion" From: Nathaniel Wooding Subject: Re: how can you solve this senaro In-Reply-To: <200908101425.n7AAmi78005365@malibu.cc.uga.edu> Content-Type: text/plain; charset="us-ascii" Here is another solution that uses a couple sorts and a data step. Nat Wooding Data one; informat patid 8. scode \$2. ; input PATID SCODE PERIOD CYCE TRT SH; cards; 5001 A11 1 1 1 47.447 5001 B50 1 1 1 48.417 5001 A50 2 1 5 67.519 5001 A61 2 1 5 64.062 5001 D40 3 1 2 21.049 5001 D41 3 1 2 20.947 run; Data one; set one; obs + 1; run; Proc sort data = one; by descending obs; run; Data One; set one; by notsorted period; if first.period then do; num = 0; sum = 0; end; num + 1; sum + SH; if last.period then Mean_SH = sum/num; drop sum num ; run; Proc sort data = one out = one ( drop = obs ); by obs; run; -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Shaik Hymad Sent: Monday, August 10, 2009 10:26 AM To: SAS-L@LISTSERV.UGA.EDU Subject: how can you solve this senaro HI ALL, PATID SCODE PERIOD CYCE TRT SH 5001 A11 1 1 1 47.447 5001 B50 1 1 1 48.417 5001 A50 2 1 5 67.519 5001 A61 2 1 5 64.062 5001 D40 3 1 2 21.049 5001 D41 3 1 2 20.947 I need output like PATID SCODE PERIOD CYCE TRT SH msh 5001 A11 1 1 1 47.447 47.93 5001 B50 1 1 1 48.417 . 5001 A50 2 1 5 67.519 65.7907 5001 A61 2 1 5 64.062 . 5001 D40 3 1 2 21.049 20.994 5001 D41 3 1 2 20.947 . how can we find mean and solve this situvation and i need above output like above one CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you. ```

Back to: Top of message | Previous page | Main SAS-L page