topic Re: replicate value (easy question) in SAS Procedures

replicate value (easy question)

Augusto — Wed, 21 Oct 2015 17:07:58 GMT

i need to replicate the value of the previos line (_n_ - 1) to line (_n_), could anyone code it.

ex.

data have ;
input n field $;
cards ;
1 y12
2 .
3 .
4 b98
5 .
6 .
7 .
;
run ;

data want;

set have;

n field
1 y12
2 y12
3 h12
4 b98
5 b98
6 b98
7 b98

run;

please, consider that this table (have) cannot be ordered

Thanks

Re: replicate value (easy question)

ndp — Wed, 21 Oct 2015 17:32:12 GMT

Simple retain statement would work.

data want;
	set have;
	retain field1;
	if not missing(field) then field1=field;
run;

Re: replicate value (easy question)

dsbihill — Wed, 21 Oct 2015 17:40:39 GMT

data want;
   set have;

   retain prevField;
   if field ne "" then prevField = field;
   if field = "" then field = prevField;

run;

Re: replicate value (easy question)

Steelers_In_DC — Wed, 21 Oct 2015 17:43:37 GMT

Here is a solution:

data have;
input n field$;
cards ;
1 y12
2 .
3 .
4 b98
5 .
6 .
7 .
;

data want;
set have;
retain field2;
if not missing(field) then field2 = field;
if missing(field) then field = field2;
drop field2;
run;