topic Finding observation and outputting that plus the row above and below in SAS Programming

Finding observation and outputting that plus the row above and below

laneylaners — Tue, 03 Nov 2015 21:48:16 GMT

Lets say I have the following dataset work.train_test:

Time	Channel	Distance
11	1	24
12	1	26
13	1	28
14	2	40
15	2	42
16	3	44

and i want to 'find' variable time when it equals 13, and then output that row plus the one above and one below it, so that a new dataset work.train_time is below:

Time	Channel	Distance
12	1	26
13	1	28
14	2	40

how would i go about doing this? do i need to use a counter? in my actual data, i know the value i want, but i do not know the time values of the ones above or below (so i cannot use a 'between' statement).

data work.train_time;

set work.train_test;

where time = 13;

(statement to output row above and below the row that outputs time = 13)

run;

Re: Finding observation and outputting that plus the row above and below

Astounding — Tue, 03 Nov 2015 22:06:51 GMT

Here's one way (untested):

data want;

set have nobs=_total_obs_;

if time=13;

output;

previous = _n_ -1;

next = _n_ + 1;

if (1 <= previous <= _total_obs_) then do;

set have point=previous;

output;

end;

if (1 <= next <= _total_obs_) then do;

set have point=next;

output;

end;

run;

Depending on the placement of the 13s, you might end up outputting the same observation twice. For example, the same record might be the next record after a 13, and might also be the previous record before the following 13. If you think that might be an issue we can code around it.

Good luck.

Re: Finding observation and outputting that plus the row above and below

MadhuKorni — Wed, 04 Nov 2015 11:35:20 GMT

data have;
input Time Channel Distance;
cnt+1;
if time = 13 then
do;
call symput('obs1',cnt-1);
call symput('obs2',cnt);
call symput('obs3',cnt+1);
end;
cards;
11 1 24
12 1 26
13 1 28
14 2 40
15 2 42
16 3 44
;

data want(drop = cnt);
set have;
if cnt in (&obs1 &obs2 &obs3);
run;