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 !
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.