DATA Step, Macro, Functions and more

Help with filling in with missing data

Reply
Frequent Contributor
Posts: 124

Help with filling in with missing data

[ Edited ]

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...

Super User
Posts: 5,082

Re: Help with filling in with missing data

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;

Ask a Question
Discussion stats
  • 1 reply
  • 169 views
  • 0 likes
  • 2 in conversation