SAS Financial Functions

SAS HMS or Hour Minute Second

What is it?

The HMS function returns a positive number, that is a SAS interpreted value for time
The time value can then be reformatted using a PUT function and TIME. format

Syntax:

HMS(hour, minute, second);

SAS HMS Statement:

SAS HMS Example:

Data work.my_data_file;

Result_1 = HMS(12,3,22);
Result_2 = PUT(Result_1, Time.);

Run;

What's happening in the script above?

The HMS(); Function is calculating the positive number in SAS that represents the Hour, Minute and Second
The PUT(); Function is converting the supplied time (43402) to something readable 12:03:22

HMS Example:

Variable	Input	Output	Description
Result_1	HMS(12,3,22)	43402	SAS numeric representation of 12:03:22
Result_2	Put(43402, Time.)	12:03:22	Re-Formatted Hour, Minute and Seconds

Connect via LinkedIn

Kevin Regan

Have an article, idea, found a typo, want to contribute? Shoot me an email Here

Below are links to some Udemy Data Science Courses. I've been using Udemy for a number of years now, and I've found their courses super helpful, maybe you will also.