BookmarkSubscribeRSS Feed
pp2014
Fluorite | Level 6

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

1 REPLY 1
Astounding
PROC Star

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;

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 920 views
  • 0 likes
  • 2 in conversation