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
Assuming you have a SAS date, numeric variable, date format then use the formula in the example:
weekday=weekday(proceduredate);
Assuming you have a SAS date, numeric variable, date format then use the formula in the example:
weekday=weekday(proceduredate);
Thanks so much ! Appreciate it !
Just figured it out
just a simple command
weekday=weekday(arrivaldate)
did it and returned a value of 1 for sunday and onwards.....nice !
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.