topic Update consecutive values based on criteria in New SAS User

Update consecutive values based on criteria

cmemtsa — Wed, 14 Oct 2020 09:03:26 GMT

data T;
input ID L EXP;
Datalines;
1 1 10
1 2 10
1 2 20
1 3 30
2 1 10
2 1 10
2 2 60
3 2 60
3 3 60
;

Hi,

I would to like to update Exp to 0 if for First.ID and L>1 for all instances of this ID (the sorting is done) i.e. the output should be

1 1 10
1 2 10
1 2 20
1 3 30
2 1 10
2 1 10
2 2 60
3 2 0
3 3 0
;

Re: Update consecutive values based on criteria

Ksharp — Wed, 14 Oct 2020 09:46:15 GMT

data T;
input ID L EXP;
Datalines;
1 1 10
1 2 10
1 2 20
1 3 30
2 1 10
2 1 10
2 2 60
3 2 60
3 3 60
;
data want;
 do until(last.id);
  set t;
  by id;
  if l<=1 then flag=1;
 end;

 do until(last.id);
  set t;
  by id;
  if not flag then exp=0;
  output;
 end;
 drop flag;
 run;

Re: Update consecutive values based on criteria

cmemtsa — Wed, 14 Oct 2020 10:26:45 GMT

Thank you! It works.