topic Re: Retaining the previous value in SAS Programming

Retaining the previous value

deleted_user — Thu, 28 May 2009 07:43:00 GMT

i have the data set like this now i wnat the previous obs repeated if the total is '.'

id age tot
1 23 9
2 23 .
3 9 .
4 10 5
3 8 .
6 7 .
5 8 1
4 3 .
2 8 .
1 6 3
3 4 .

ouput

id age tot
1 23 9
2 23 9
3 9 9
4 10 5
3 8 5
6 7 5
5 8 1
4 3 1
2 8 1
1 6 3
3 4 3

in this if the total is '.' then the previous value shd come there

Re: Retaining the previous value

GertNissen — Thu, 28 May 2009 08:34:11 GMT

This is one way of doing it 🙂

data input;
input id age tot;
datalines;
1 23 9
2 23 .
3 9 .
4 10 5
3 8 .
6 7 .
5 8 1
4 3 .
2 8 .
1 6 3
3 4 .
;
run;
data output;
set input;
retain new_tot;
if tot > . then new_tot=tot;
run;

Re: Retaining the previous value

deleted_user — Thu, 28 May 2009 09:52:14 GMT

thqs got it