topic Datetime in New SAS User

Datetime

msingam — Mon, 12 Oct 2020 00:23:47 GMT

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

Re: Datetime

jimbarbour — Mon, 12 Oct 2020 00:03:48 GMT

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.);

Re: Datetime

PaigeMiller — Mon, 12 Oct 2020 00:00:37 GMT

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.

Re: Datetime

jimbarbour — Mon, 12 Oct 2020 00:38:06 GMT

@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