topic Re: next observation in SAS Procedures

next observation

sasphd — Fri, 12 Sep 2014 20:29:26 GMT

Hello,

I know that when we want the previous observation, we use (lag) function

What can I use when I want next observation?

MikeZdeb — Fri, 12 Sep 2014 20:38:40 GMT

here's one idea ...

data new;

merge sashelp.class (keep=height) sashelp.class (firstobs=2 keep=height rename=(height=nextheight));

run;

Obs Height nextheight

1 69.0 56.5

2 56.5 65.3

3 65.3 62.8

4 62.8 63.5

5 63.5 57.3

6 57.3 59.8

7 59.8 62.5

8 62.5 62.5

9 62.5 59.0

10 59.0 51.3

11 51.3 64.3

12 64.3 56.3

13 56.3 66.5

14 66.5 72.0

15 72.0 64.8

16 64.8 67.0

17 67.0 57.5

18 57.5 66.5

19 66.5 .

Hima — Fri, 12 Sep 2014 20:39:32 GMT

stat_sas — Fri, 12 Sep 2014 20:54:32 GMT

data have;
input a;
datalines;
1
2
3
4
5
;

Proc sql;
Select have.a, next.a as next_obs
from have left join have as next
on have.a + 1 = next.a;
Quit;

MikeZdeb — Fri, 12 Sep 2014 21:36:15 GMT

Hi ... have you tried your solution with some data other than 1 2 3 4 5 (anything that is not just a bunch of consecutive values)?

stat_sas — Fri, 12 Sep 2014 21:48:01 GMT

Hi,

Please see below.

data have;
input Obs    Height;
datalines;
1     69.0
2     56.5
3     65.3
4     62.8
5     63.5
;

Proc sql;
Select have.*, next.*
from have left join have as next
on have.obs + 1 = next.obs;
Quit;