topic Re: Military Time in SAS Procedures

Military Time

SriCh1 — Sun, 02 May 2021 21:06:26 GMT

I have an excel sheet where the data set has columns with military time but no separators. How to convert the military time to hh: mm. For example, the columns have military time like 1509,7,30,637.

Re: Military Time

PGStats — Sun, 02 May 2021 21:38:54 GMT

According to which standard (reference) ?

Re: Military Time

SriCh1 — Sun, 02 May 2021 21:43:15 GMT

Military time is 24 hr time, but it is in 1507 format which is 03:07 PM, I want to convert all the values to HH MM format.

Re: Military Time

PGStats — Sun, 02 May 2021 21:55:48 GMT

time = hms(input(substr(mTime,1,2), best.), input(substr(mTime,3,2), best.), 0);

Re: Military Time

SriCh1 — Sun, 02 May 2021 22:14:02 GMT

Is the solution for SAS?

Re: Military Time

SriCh1 — Sun, 02 May 2021 22:22:04 GMT

The given solution did not work but I can provide you with an example of the dataset.

COLLECTION_TIME	RECV_TIME
1509	613
2033	625
30	615
2130	603
2114	720
1009	639
1457	553
2131	634
627	550
1702	632

Re: Military Time

PaigeMiller — Sun, 02 May 2021 22:25:59 GMT

Show us the code you used and the results. Explain what was wrong with the answers.

Re: Military Time

SriCh1 — Sun, 02 May 2021 22:31:53 GMT

I tried the code but the values were all missing

Re: Military Time

PaigeMiller — Sun, 02 May 2021 22:40:37 GMT

Repeating: "Show us the code you used"

Re: Military Time

SriCh1 — Sun, 02 May 2021 22:56:23 GMT

time = hms(input(substr(mTime,1,2), best.), input(substr(mTime,3,2), best.), 0);

Re: Military Time

PaigeMiller — Sun, 02 May 2021 22:59:10 GMT

If you didn't change the variable names from the code by @PGStats to the varaible names in your data set, then I would expect missing values.

Show us the whole data step. Also, if there are any WARNINGs in the log, show those to us as well. (or just show us the entire LOG from this data step including CODE, ERRORs, WARNINGs and NOTEs)

Re: Military Time

PGStats — Mon, 03 May 2021 00:03:37 GMT

data have;
input COLLECTION_TIME $ RECV_TIME $;
datalines;
1509    613
2033    625
30  615
2130    603
2114    720
1009    639
1457    553
2131    634
627 550
1702    632
;

data want;
set have;
t = input(COLLECTION_TIME, best.);
COLLECTION_TIME_DT = hms(int(t/100), mod(t,100), 0);
t = input(RECV_TIME, best.);
RECV_TIME_DT = hms(int(t/100), mod(t,100), 0);
format COLLECTION_TIME_DT RECV_TIME_DT hhmm5.;
run;

proc print data=want; run;

Re: Military Time

SriCh1 — Mon, 03 May 2021 01:11:05 GMT

So how can we enter all the observations from the dataset under datalines if we have more than 3000 observations?

Re: Military Time

SriCh1 — Mon, 03 May 2021 01:24:17 GMT

Thank you so much the code worked!

Re: Military Time

Tom — Mon, 03 May 2021 04:09:41 GMT

@SriCh1 wrote:
So how can we enter all the observations from the dataset under datalines if we have more than 3000 observations?

Why would you want to do that if you already have the data in the dataset you imported from Excel?