topic After using the LOCF imputation method in SAS Programming

After using the LOCF imputation method

teja5959 — Thu, 07 Jun 2018 11:47:57 GMT

Hi how to do locf in this way.

data val1;

input visit $10. value ;

cards;

Week 2 1.5

Week 4 2.3

Week 8 3.2

run;

how to get this output.

VISIT VALUE

Week 2 1.5

Week 4 2.3

Week 6 2.3

Week 8 3.2

Week 10 3.2

Week 12 3.2

Re: After using the LOCF imputation method

RW9 — Thu, 07 Jun 2018 12:02:30 GMT

Much the same as your other question:

https://communities.sas.com/t5/Base-SAS-Programming/visitnum-carry-forward-locf/m-p/468307

Re: After using the LOCF imputation method

teja5959 — Thu, 07 Jun 2018 12:17:49 GMT

it's not working

Re: After using the LOCF imputation method

Kurt_Bremser — Thu, 07 Jun 2018 12:21:29 GMT

@teja5959 wrote:

it's not working

This is an extremely unhelpful statement. You'd be pissed if @RW9 just answered "It's working", and nothing else, eh?

So post your code and your log, and where the result differs from your expectations, so we can test what's "not working".

Re: After using the LOCF imputation method

Ksharp — Thu, 07 Jun 2018 13:17:41 GMT

data val1;
input visit & $10. value ;
cards;
Week 2   1.5
Week 4   2.3
Week 8   3.2
;
run;
data want;
 merge val1 val1(firstobs=2 keep=visit rename=(visit=_visit)) end=last;
 array x{6} $32 _temporary_ ('Week 2' 'Week 4' 'Week 6' 'Week 8' 'Week 10' 'Week 12');
 output;
 do i=whichc(visit,of x{*})+1 to ifn(last,6,whichc(_visit,of x{*})-1);
   visit=x{i};output;
 end;
 drop i _visit;
run;

proc print;run;