topic Weekday from Date in SAS Programming

Weekday from Date

Venki — Tue, 02 Jun 2015 23:59:53 GMT

Hello SAS community.

I have a large dataset of 7500 subjects with procedure dates in mm/dd/yyyy format and I need to know which weekday the procedure date would be; I am trying to basically analyze if subjects who had procedures during weekday (monday to friday) and during regular work time (7am-7pm) compared to off-peak hours (7pm-7am on mon to friday AND sat, sun)

Is there a way to know that.

SAS instructions says:

WEEKDAY( date )

returns the day of the week from a SAS date value. For example WEEKDAY=WEEKDAY(’17OCT1991’D); returns , the numerical value for Thursday.

But, I am not quite sure how to use this..

I havevariable "proceduredate" in mm/dd/yyyy format.

Can anyone help?

Thanks and appreciate your time

Venki

Re: Weekday from Date

Reeza — Wed, 03 Jun 2015 00:05:01 GMT

Assuming you have a SAS date, numeric variable, date format then use the formula in the example:

weekday=weekday(proceduredate);

Re: Weekday from Date

Venki — Wed, 03 Jun 2015 00:18:58 GMT

Just figured it out

just a simple command

weekday=weekday(arrivaldate)

did it and returned a value of 1 for sunday and onwards.....nice !

Re: Weekday from Date

Venki — Wed, 03 Jun 2015 00:20:00 GMT

Thanks so much ! Appreciate it !