Help with filling in with missing data

pp2014 — Mon, 02 Nov 2015 20:04:52 GMT

I have the following data

data have;

input id $2. call_dt mmddyy10. hr $6.;

cards;

12 10/06/2015 10 am

12 10/06/2015 12 pm

12 10/06/2015 2 pm

12 10/06/2015 5 pm

I want the following output with missing hours added to the final output:

id call_dt hr

12 10/06/2015 10 am

12 10/06/2015 11 am

12 10/06/2015 12 pm

12 10/06/2015 1 pm

12 10/06/2015 2 pm

12 10/06/2015 3 pm

12 10/06/2015 4 pm

12 10/06/2015 5 pm

Any help will be greatly appreciated...

Re: Help with filling in with missing data

Astounding — Mon, 02 Nov 2015 21:40:25 GMT

Assuming nothing is being left to the imagination (such as the presence of additional variables), the easiest way might be:

proc sort data=have (keep=id call_dt) nodupkey;

by id call_dt;

run;

data want;

set have;

do hr = '10 am', '11 am', '12 pm', ' 1 pm', ' 2 pm', ' 3 pm', ' 4 pm', ' 5 pm';

output;

end;

run;