Date and Time Operators :: SAS® Visual Analytics 7.4: User's Guide

DateFromMDY

creates a date value from separate month, day, and year values. The first value specifies the month as a number from 1–12. The second value specifies the day as a number from 1–31. The third value specifies the year as a four-digit number.

For example,

DateFromMDY(1,
                                 15, 2013)

returns 15JAN2013.

DateFromYQ

creates a date value from separate year and quarter values. The first value specifies the year as a four-digit number. The second value specifies the quarter as a number from 1–4.

For example,

DateFromYQ(2013,
                                 1)

returns 01JAN2013.

Note: The date is generated using the first day of each quarter.

DatePart

converts a datetime value to a date value.

For example, DatePart('15JAN2013_17:15'dt) returns 15JAN2013.

DateTimeFromDateHMS

creates a datetime value from a date value and separate hour, minute, and second values. The first value specifies the date. The second value specifies the hour as a number from 0–23. The third value specifies the minute as a number from 0–59. The fourth value specifies the second as a number from 0–59.

For example,

DateTimeFromDateHMS('15JAN2013'd,
                                 17, 15, 23)

returns January 15, 2013 05:15:23 PM

DateTimeFromTimeMDY

creates a datetime value from a time value and separate month, day, and year values. The first value specifies the time. The second value specifies the month as a number from 1–12. The third value specifies the day as a number from 1–31. The fourth value specifies the year as a four-digit number.

For example,

DateTimeFromTimeMDY('_17:15:23'dt,
                                 1, 15, 2013)

returns January 15, 2013 05:15:23 PM.

DayOfMonth

returns the day of the month from a date value as a number from 1–31.

For example, DayOfMonth('15JAN2013'd) returns 15.

DayOfWeek

returns the day of the week from a date value as a number from 1–7 (1 is Sunday).

For example, DayOfWeek('15JAN2013'd) returns 3 (Tuesday).

DayOfYear

returns the day of the year from a date value as a number from 1–366.

For example, DayOfYear('15FEB2013'd) returns 46.

Hour

returns the hour from a time or datetime value as a number from 0–23.

For example, Hour('17:15:23't) returns 17.

Minute

returns the minute from a time or datetime value as a number from 0–59.

For example, Minute('17:15:23't) returns 15.

Month

returns the month from a date value as a number from 1–12.

For example, Month('15JAN2013'd) returns 1.

Now

creates a datetime value from the current date and time.

For example, Now() returns the current date and time.

Quarter

returns the quarter from a date value as a number from 1–4.

For example, Quarter('15AUG2013'd) returns 3.

Second

returns the second from a time or datetime value as a number from 0–59.

For example, Second('17:15:23't) returns 23.

TimeFromHMS

creates a time value from separate hour, minute, and second values. The first value specifies the hour as a number from 0–23. The second value specifies the minute as a number from 0–59. The third value specifies the second as a number from 0–59.

For example,

TimeFromHMS(17,
                                 15, 23)

returns 05:15:23 PM.

TimePart

converts a datetime value to a time value.

For example, TimePart('15JAN2013_17:15:23'dt) returns 05:15:23 PM.

WeekNumber

returns the week of the year as a number from 0–53, where week 1 begins on the first Sunday of the year. Dates before the first Sunday of the year return 0.

For example, WeekNumber('04AUG2013'd) returns 31.

Year

returns the year from a date value as a four-digit number.

For example, Year('15JAN2013'd) returns 2013.