topic Re: How to derive WOCF? in SAS Programming

How to derive WOCF?

dpa — Wed, 23 Sep 2020 19:23:11 GMT

Hi I want to use WOCF for my dataset but How can you do that. so I have two dataset code which one i have and what i want. please help me I tried Lag but didn't succeed.

data have;
input id $ visitnum aval ;
datalines;
1 1 0
1 2 3
1 3 3
1 4 4
1 5 3
1 6 3
1 7 3
1 8 4
1 9 4
;
run;

data want;
input id $ visitnum aval dtype ;
datalines;
1 1 0
1 2 3
1 3 3
1 4 4
1 5 4 WOCF
1 6 4 WOCF
1 7 4 WOCF
1 8 4
1 9 4
;

run;

Re: How to derive WOCF?

Reeza — Wed, 23 Sep 2020 19:35:56 GMT

What is WOCF?
Worst observation carried forward?

Re: How to derive WOCF?

Reeza — Wed, 23 Sep 2020 19:36:50 GMT

Lag or DIF or RETAIN are options. Show the code you tried with Lag please.

Re: How to derive WOCF?

dpa — Wed, 23 Sep 2020 19:44:35 GMT

yes

Re: How to derive WOCF?

dpa — Wed, 23 Sep 2020 20:00:23 GMT

with Lag function I only manqged to change next one but i don't know how to do that with other two .

Re: How to derive WOCF?

Kurt_Bremser — Wed, 23 Sep 2020 20:09:46 GMT

retain _aval;
if first.id then _aval = aval;
if aval lt _aval
then do;
  aval = _aval;
  dtype = 'WOCF';
end;
else _aval = aval;
drop _aval;