topic Re: read and compare next observation in sas in SAS Programming

read and compare next observation in sas

Aexor — Sun, 23 May 2021 07:07:15 GMT

Hi,

I have this table:

I want to set a flag if any value change is there from the previous one.

as shown below:

id flag

1 N

0 Y

0 N

1 Y

0 Y

1 Y

here i tried using lag function and compare the value to get flag. Please suggest any other ways to do it.

Thanks

Re: read and compare next observation in sas

Kurt_Bremser — Sun, 23 May 2021 07:17:34 GMT

The LAG function is the proper tool for this, use it (Maxim 14).

Re: read and compare next observation in sas

PeterClemmensen — Sun, 23 May 2021 09:57:33 GMT

data have;
input id;
datalines;
1
0
0
0
1
0
1
;

data want;
   set have;
   flag = ifc(id = lag(id) | _N_ = 1, "N", "Y");
run;

Re: read and compare next observation in sas

Aexor — Sun, 23 May 2021 11:38:23 GMT

Thanks. yes I tried with lag function only. just wanted to check is there any other way to compare values in variable?
Can we run a loop , array ? please suggest

Re: read and compare next observation in sas

singhsahab — Sun, 23 May 2021 11:42:59 GMT

@Aexor alternate solution with the help of proc sql;

data have;
input id;
datalines;
5
0
0
0
1
0
1
;

proc sql noprint;
create table have1 as
select *,monotonic() as c from have;
create table WANT as
select a.id,ifc(a.id eq b.id | a.c=1,'N','Y') as flag from have1 as a left join have1 as b on a.c=b.c+1;
quit;

Thank you