retain the last value by group

[Claus_Stenberg]

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 ? 

[Kurt_Bremser · Accepted solution]

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

[Claus_Stenberg]

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