Combine HH and MM and am/pm into HH:MM time variable

[sanketshah07]

Hello,

I have hours, minutes and am/pm as three seperate columns. I need to concatenate these to form one HH:MM variable, preferable 24 hour clock, so that I can gt and lt functions with the time. Any advice?

[PaigeMiller · Accepted solution]

if upcase(ampm) = 'AM' then time=hms(hours,minutes,0);
else if upcase(ampm) = 'PM' then time=hms(hours+12,minutes,0);

[sanketshah07]

What do I use to format the time back to HH:MM?

[PaigeMiller]

You can use the HHMM. format

[sanketshah07]

Thanks so much 🙂

[singhsahab]

proc sql;
create table want as
select hh,mm,ampm , case when ampm='am' then hms(hh,mm,0) else hms(hh+12,mm,0) end as time format=hhmm. from have;
quit;