On Thu, 1 Feb 2007 13:13:52 +0530, Peeyush Agarwal <peeyush.agarwal@EVALUESERVE.COM> wrote:

>Dear All, > >Please refer to the email below. > >I would be obliged if you can asap provide a solution. > >Regards, >Peeyush

1. You have already received solutions for the "simple" case.

2. You have failed to clearly explain and illustrate the "second issue".

3. There is a 50% surcharge for "urgent" answers :-) .

> >-----Original Message----- >From: Peeyush Agarwal [mailto:Peeyush.Agarwal@EVALUESERVE.COM] >Sent: Wednesday, January 31, 2007 7:17 PM >To: SAS-L@LISTSERV.UGA.EDU >Cc: Peeyush Agarwal >Subject: How to compare subsequent values in a column? > >How to do a simple ratio calculation << row2 value/row1 value >> and so >on >for the whole data set? > >The next aspect of my problem relates to doing this ratio calculation >for >a >varying number of grouped observations. If there are many groups in the >data and each group has several rows and the number of rows do not >match, >how we can do it then. I can try to work around the second issue, but >would >need some quick help for the first issue. > > >The information in this e-mail is the property of Evalueserve and is >confidential and privileged. It is intended solely for the addressee. >Access to this email by anyone else is unauthorized. If you are not the >intended recipient, any disclosure, copying, distribution or any action >taken in reliance on it is prohibited and will be unlawful. If you >receive >this message in error, please notify the sender immediately and delete >all >copies of this message. > > > >The information in this e-mail is the property of Evalueserve and is confidential and privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken in reliance on it is prohibited and will be unlawful. If you receive this message in error, please notify the sender immediately and delete all copies of this message.