How to replace the "missing value ." between 2000/01/02 and 2000/02/15 with the value "5" on 2000/01/01?
ID DATE Variable
01 2000/01/01 5
01 2000/01/02 .
01 2000/01/03 .
01 2000/01/04 .
01 2000/01/05 .
.................
01 2000/02/15 .
01 2000/02/16 7
Assuming that there are many ID like '01' and many case like missing value between 2000/01/02 and 2000/02/15. Is there any efficient way to replace these missing value with the most recently available value like '5' in this case before new value like '7' is available?
data have;
input ID$ DATE:yymmdd10. Variable;
format DATE yymmdd10.;
datalines;
01 2000/01/01 5
01 2000/01/02 .
01 2000/01/03 .
01 2000/01/04 .
01 2000/01/05 .
01 2000/02/15 .
01 2000/02/16 7
;
data want;
update have(obs=0) have;
by ID;
output;
run;
data have;
input ID$ DATE:yymmdd10. Variable;
format DATE yymmdd10.;
datalines;
01 2000/01/01 5
01 2000/01/02 .
01 2000/01/03 .
01 2000/01/04 .
01 2000/01/05 .
01 2000/02/15 .
01 2000/02/16 7
;
data want;
update have(obs=0) have;
by ID;
output;
run;
You'll find the answer to the antecedent to this topic in How to merge daily and quarterly dataset
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.