Weekday from Date

[Venki]

   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

[Reeza · Accepted solution]

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

weekday=weekday(proceduredate);

[Venki]

Thanks so much ! Appreciate it !

[Venki]

Just figured it out

just a simple command

weekday=weekday(arrivaldate)

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