Language Reference


Date and Time Functions

DATDIF

returns the number of days between two dates

DATE

returns the current date as a SAS date value

DATEJUL

converts a Julian date to a SAS date value

DATEPART

extracts the date from a SAS datetime value

DATETIME

returns the current date and time of day as a SAS datetime value

DAY

returns the day of the month from a SAS date value

DHMS

returns a SAS datetime value from date, hour, minute, and seconds

HMS

returns a SAS time value from hour, minute, and seconds

HOLIDAY

returns the date of the specified holiday for the specified year

HOUR

returns the hour from a SAS time or datetime value

INTCINDEX

returns the cycle index when a date, time, or datetime interval and value are specified

INTCK

returns the integer number of time intervals in a given time span

INTCYCLE

returns the date, time, or datetime interval at the next higher seasonal cycle

INTFIT

returns a time interval that is aligned between two dates

INTFMT

returns a recommended SAS format when a date, time, or datetime interval is specified

INTGET

returns a time interval based on three date or datetime values

INTINDEX

returns the seasonal index when a date, time, or datetime interval and value are specified

INTNX

advances a date, time, or datetime value by a given interval, and returns a date, time, or datetime value

INTSEAS

returns the length of the seasonal cycle when a date, time, or datetime interval is specified

INTSHIFT

returns the shift interval that corresponds to the base interval

INTEST

returns 1 if a time interval is valid, and returns 0 if a time interval is invalid

JULDATE

returns the Julian date from a SAS date value

JULDATE7

returns a seven-digit Julian date from a SAS date value

MDY

returns a SAS date value from month, day, and year values

MINUTE

returns the minute from a SAS time or datetime value

MONTH

returns the month from a SAS date value

NWKDOM

returns the date for the nth occurrence of a weekday for the specified month and year

QTR

returns the quarter of the year from a SAS date value

SECOND

returns the second from a SAS time or datetime value

TIME

returns the current time of day

TIMEPART

extracts a time value from a SAS datetime value

TODAY

returns the current date as a SAS date value

WEEKDAY

returns the day of the week from a SAS date value

YEAR

returns the year from a SAS date value

YRDIF

returns the difference in years between two dates

YYQ

returns a SAS date value from the year and quarter