[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: An Alternative to LAG function
From:       Chang Chung <chang_y_chung () HOTMAIL ! COM>
Date:       2005-10-31 20:15:42
[Download RAW message or body]

On Mon, 31 Oct 2005 13:22:49 -0500, Richard A. DeVenezia
<radevenz@IX.NETCOM.COM> wrote:

>Hi Chang:
>
>I might suggest the # symbol as the operator for this language construct.
>It fits nicely with the concept of # as line number in input, put and window
>statements.  [] () and {} are ingrained as rowwise array address bounders.
>
>var#n  fetches value of var at row n
>var#-n fetches value of var at nth prior row
>var#+n fetches value of var at nth next row
>var#(expression)  value of var at row of evaluated expression
>var#-(expression)  value of var at evaluated expression prior row
>var#+(expression)  value of var at evaluated expression next row.

Hi, Richard,
Makes perfect sense. You should be the head architect of the sas language!!
Cheers,
Chang

[prev in list] [next in list] [prev in thread] [next in thread]