topic Re: SAS Equivalent for "convert" and "dateadd" functions in SQL server in New SAS User

SAS Equivalent for "convert" and "dateadd" functions in SQL server

bobbym — Mon, 08 Oct 2018 18:24:19 GMT

Hi All,

I have a sql function to convert a date-timestamp field that is numeric to a valid date format. I am trying to find if there is an equivalent function/script in SAS that could get me the same results like the following SQL server stmt:

cast(dateadd(s, convert(bigint, CREATED_TIME) / 1000, convert(datetime, '1-1-1970 00:00:00')) as char)

Re: SAS Equivalent for "convert" and "dateadd" functions in SQL server

mbuchecker — Mon, 08 Oct 2018 18:35:01 GMT

use either the datepart function for extracting just the date. IE: datepart(variable) there is also the INTNX for adding dates.

Re: SAS Equivalent for "convert" and "dateadd" functions in SQL server

bobbym — Mon, 08 Oct 2018 19:25:02 GMT

Datepart is just returning nulls

Re: SAS Equivalent for "convert" and "dateadd" functions in SQL server

ChrisHemedinger — Tue, 09 Oct 2018 01:43:41 GMT

If the stored value is a datetime in epoch format (or Unix datetime), you need to first convert to a SAS datetime value. Basically, that's adjusting the value by 10 years worth of seconds -- or milliseconds depending on how the data is stored. See How to convert a Unix datetime to SAS.

/* Number of seconds between 01JAN1960 and 01JAN1970: 315619200 */
sasDT = unixDT + 315619200;

/* OR */

/* DHMS function calculates datetime when you provide values for */
/*    date, hour, minute, and seconds                            */
/* In this case, "seconds" is a very high value!                 */
sasDT = dhms('01jan1970'd, 0, 0, unixDT);

Once in a SAS datetime, you can use DATEPART() to get just the date value, and INTNX to add/subtract timespans at any interval (days, hours, seconds, months, years, and more).

Re: SAS Equivalent for "convert" and "dateadd" functions in SQL server

bobbym — Tue, 09 Oct 2018 18:27:22 GMT

Thanks Chris. That worked