Weekday from Date

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

Weekday from Date

   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


Accepted Solutions
Solution
‎06-02-2015 08:05 PM
Super User
Posts: 17,819

Re: Weekday from Date

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

weekday=weekday(proceduredate);

View solution in original post


All Replies
Solution
‎06-02-2015 08:05 PM
Super User
Posts: 17,819

Re: Weekday from Date

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

weekday=weekday(proceduredate);

Contributor
Posts: 21

Re: Weekday from Date

Thanks so much ! Appreciate it !

Contributor
Posts: 21

Re: Weekday from Date

Just figured it out

just a simple command

weekday=weekday(arrivaldate)

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 204 views
  • 1 like
  • 2 in conversation