topic Re: Minusing first obs with another leaving first observation in SAS Procedures

Minusing first obs with another leaving first observation

R_Win — Fri, 19 Sep 2008 08:30:23 GMT

i have ao datasets i want to minus the first observation by another

data x;
input id sal;
cards;
1 2
3 4
5 6
7 8
run;

i want like this id -sal by leaving the first observariopn 1-4,3-6,5-8 finally the output shd be like this.

Re: Minusing first obs with another leaving first observation

yonib — Fri, 19 Sep 2008 12:37:28 GMT

You can use the lag function/
If i take your example it may look like this:

data b;
set x;
w=lag(id)-sal;
run;

Re: Minusing first obs with another leaving first observation

sbb — Fri, 19 Sep 2008 12:39:35 GMT

A DATA step and investigate using the LAG function to use variable values from a previous observation. Have a look at the SAS.COM support website and the SAS Language Guide discussion on the LAG function. Also, there are also technical papers from prior conferences available on the website.

Scott Barry
SBBWorks, Inc.