topic Re: create columns using the row value of another column in New SAS User

create columns using the row value of another column

usuario_estudo — Mon, 06 Apr 2020 16:13:26 GMT

Table Have

Table Want

I want to create a code to create the column Y, whose value will be:

when ID<ID_REF, then Y=X,
when ID>=ID_REF, then Y will always have the same value, which will be the value of X when ID=ID_REF

novinosrin — Mon, 06 Apr 2020 16:18:13 GMT

data want;
 set have;
 by id_ref;
 retain y;
 if first.id_ref then call missing(y);
 if ID<=ID_REF then y=x;
run;

PGStats — Mon, 06 Apr 2020 18:14:49 GMT

I would do:

data want;
retain y;
set have;
if id <= id_ref then y = x;
output;
if id < id_ref then call missing (y);
run;