topic Filling in Missing Dates Sequentially in SAS Programming

Filling in Missing Dates Sequentially

yawenyu929 — Sun, 02 Aug 2020 02:42:28 GMT

Hello All,

I'm a new SAS user attempting to fill in some missing dates in my dataset. I have visits and visit numbers with corresponding start and end dates. I have all visit information, but not all dates:

How can I add the missing dates based on visit without overwriting the existing ones? Also, gaps in dates are not consistent. Some subjects are missing one date, others are missing more. Any help would be appreciated!

Re: Filling in Missing Dates Sequentially

mkeintz — Sun, 02 Aug 2020 03:15:20 GMT

I don't understand what you want your output to look like. Could you show what the output should look like, corresponding to the input you have provided?

Re: Filling in Missing Dates Sequentially

yawenyu929 — Mon, 03 Aug 2020 01:59:53 GMT

Hello,

I'd my output to have all the missing dates filled in. If the last date is left off at 05Mar2020, then the next should be 06Mar2020, then 07Mar2020, then 08Mar2020, and so on until the next non-missing date. Hope this helps!

Re: Filling in Missing Dates Sequentially

mkeintz — Mon, 03 Aug 2020 03:40:32 GMT

You have not provided a sas data step to reveal the names of your variables, and I am not going to make a data step out of your png file. So here goes, assuming your date variable names are DATE1 and DATE2:

data want;
    set have;
    date1=coalesce(date1,lag(date1)+1);
    date2=coalesce(date2,lag(date2)+1);
run;