SAS Financial Functions

SAS Date Time

What is it?

The Date Time function returns the number of seconds from Jan 1, 1960 to the current date.
The number can then be re-formated using the PUT function to something more easily readable

Syntax:

datetime();

SAS Date Time:

SAS Date Time Example:

Data work.my_data_file;

Result_1 = Datetime();
Result_2 = PUT(Result_1, nldatm.);

Run;

What's happening in the script above?

The DateTime(); Function is calculating the number of seconds from January 1st 1960 to the current date time
The PUT(); Function is converting the supplied Datetime in seconds (1934061623.7) to something readable 14Apr2021:23:20:24

Date Time Example:

Variable	Input	Output	Description
Result_1	Datetime();	1934061623.7	SAS seconds through April 14th 2021 at 11:20:24
Result_2	Put(1934061623.7, nldatm.)	14Apr2021:23:20:24	Re-Formatted seconds value to a human readable date

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.