topic Re: retain the last value by group in SAS Programming

retain the last value by group

Claus_Stenberg — Wed, 24 Nov 2021 11:58:00 GMT

Hi folks

I want some observations (obs) by group (place) and time (timepoint)

data have;
input place $ timepoint obs;
datalines;
a  1.1   0
a  1.2   0
a  1.3   1
a  1.4   0
a  1.5   0
b  1.1   0
b  1.2   1
b  1.3   0
b  1.4   2
b  1.5   0
;
run;

data want;
set have;
...
run;

What I want is to retain the last obs by place to the dataset looks like this

Any idea on how to do this ?

Re: retain the last value by group

Kurt_Bremser — Wed, 24 Nov 2021 12:01:20 GMT

data want;
set have;
by place;
retain retain_obs;
if first.place then retain_obs = .;
if obs ne 0 then retain_obs = obs;
run;

Re: retain the last value by group

Claus_Stenberg — Thu, 25 Nov 2021 12:28:15 GMT

Thanks a lot - nice and simple. Works like a charm 😀