topic Re: Combine HH and MM and am/pm into HH:MM time variable in SAS Programming

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

sanketshah07 — Thu, 18 Oct 2018 18:04:25 GMT

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?

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

PaigeMiller — Thu, 18 Oct 2018 18:09:36 GMT

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

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

sanketshah07 — Thu, 18 Oct 2018 18:58:01 GMT

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

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

PaigeMiller — Thu, 18 Oct 2018 21:46:07 GMT

You can use the HHMM. format

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

singhsahab — Fri, 19 Oct 2018 14:35:06 GMT

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;

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

sanketshah07 — Tue, 23 Oct 2018 21:08:28 GMT

Thanks so much 🙂