topic Creating TimeStamp with Hour and Minute Values in SAS Programming

Creating TimeStamp with Hour and Minute Values

Anirudh9 — Fri, 21 Sep 2018 15:54:02 GMT

I have the following table

Hour Minute

1 10

16 34

23 15

2 9

I want the resulting table to look like this

Hour Minute Time

1 10 01:10

16 34 16:34

23 15 23:15

2 9 02:09

Re: Creating TimeStamp with Hour and Minute Values

novinosrin — Fri, 21 Sep 2018 15:57:22 GMT

This is easy

data have;
input Hour    Minute;
cards;
1          10
16         34
23         15
2           9
;
data want;
set have;
time=hms(hour,minute,0);
format time time5.;
run;

Re: Creating TimeStamp with Hour and Minute Values

Anirudh9 — Fri, 21 Sep 2018 16:48:46 GMT

Thank you so much!