topic Re: LOCF in SAS Programming

LOCF

Jack2012 — Mon, 19 Oct 2020 09:14:25 GMT

Dear All,

I want to impute the missing obs with previous value, but have no idea, though I referred below good link: https://communities.sas.com/t5/SAS-Programming/Last-Observation-Carried-Foward/m-p/309339#M66511

Yes, all the missing variable should be imputed from the previous value, as this would be the accumulative number of subjects till some timepoint.

The datafile in xlsx has been attached.

Thank you.

Kurt_Bremser — Mon, 19 Oct 2020 09:35:25 GMT

Please post example data in usable form, as shown here

Kurt_Bremser — Mon, 19 Oct 2020 09:38:56 GMT

The generic way to carry over is this:

data want;
set have;
retain _var1;
if var1 ne . /* if var1 is numeric, otherwise "" */
then _var1 = var1;
else var1 =_var1;
drop _var1;
run;

Jack2012 — Mon, 19 Oct 2020 22:09:02 GMT

Perfect, that is what I want.