Datetime

[msingam]

How to create hour,  minute, and second variables from datetimes formatted like 14may1998 05:43:32

[jimbarbour · Accepted solution]

Something like this I think:

Hour = SUBSTR(result_dts, 11, 2);
Minute = SUBSTR(result_dts, 14, 2);
Second = SUBSTR(result_dts, 17, 2);

Jim

Results:

P.S.  The above code will give you character values.  If you need to perform any type of numeric operations, you'll need to turn them into numeric variables by wrapping them in an INPUT() function.  Like this:

	Hour	=	INPUT(SUBSTR(result_dts, 11, 2), 2.);
	Minute	=	INPUT(SUBSTR(result_dts, 14, 2), 2.);
	Second	=	INPUT(SUBSTR(result_dts, 17, 2), 2.);

[PaigeMiller]

 If result_dts is really a datetime value, then

hour=hour(timepart(result_dts));
minute=minute(timepart(result_dts));

Seconds follows the same pattern, so I leave it up to you as a homework assignment.

[jimbarbour]

@PaigeMiller,

I was wondering that myself, whether it was formatted text or a formatted SAS date. I guessed that it was text because of the lack of a colon between the date and the time.  I suppose that I guessed right, but your info is useful info either way since working with SAS dates is such a common need (as you well know I'm sure).

Jim