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 !
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.