backward fill and forward fill

Aphreven — Tue, 03 Oct 2023 15:17:04 GMT

Hello I would like to do something very simple but that I struggle with :

I have a table with several columns and 1 specifically that have missing values that i want to fill with a backward then a forward fill stragegy based on a ID column.

have :

ID colA colB Coltofill

1 ... ...

1 5

2 12

want :

ID colA colB Coltofill

1 ... ... 5

1 5

2 12

More precisely i want to only fill the col "Coltofill". I found a good reponse in this post : https://communities.sas.com/t5/SAS-Programming/Backward-and-Forward-Filling-Information/m-p/699624 But the problem is that it fills every columns.

Thank you !

Re: backward fill and forward fill

Kurt_Bremser — Tue, 03 Oct 2023 15:23:56 GMT

proc sql;
create table want as
  select
    id, cola, colb,
    max(coltofill) as coltofill
  from have
  group by id
;
quit;

topic backward fill and forward fill in New SAS User

backward fill and forward fill

Re: backward fill and forward fill