topic Weekdays in DATA SET in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Weekdays-in-DATA-SET/m-p/134816#M36524 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Is there a command to show the working days a year in a data set?</P></BODY></HTML> Mon, 09 Jun 2014 19:17:33 GMT hugo_spss 2014-06-09T19:17:33Z Weekdays in DATA SET https://communities.sas.com/t5/SAS-Procedures/Weekdays-in-DATA-SET/m-p/134816#M36524 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Is there a command to show the working days a year in a data set?</P></BODY></HTML> Mon, 09 Jun 2014 19:17:33 GMT https://communities.sas.com/t5/SAS-Procedures/Weekdays-in-DATA-SET/m-p/134816#M36524 hugo_spss 2014-06-09T19:17:33Z Re: Weekdays in DATA SET https://communities.sas.com/t5/SAS-Procedures/Weekdays-in-DATA-SET/m-p/134817#M36525 <HTML><HEAD></HEAD><BODY><P>You will need to qualify what you mean by "weekdays" or "workdays" in a data set. You can set a flag for a given SAS date type variable as to whethere it is a weekday but the code varies by national location.</P><P></P><P>For example in a data step given a SAS data variable called date:</P><P></P><P>WeekDayFlag = (weekday(date) in (2,3,4,5,6)); /* will set a value of 1 for Monday through Friday in most US installations and 0*/</P><P></P><P>And if you mean workdays to exclude certain holidays or observances you will need to define them. Also does the organization work on Saturday?</P><P></P><P>There is a Holiday function that return the date of some holidays for a given year but if you have something not on that list ...</P><P></P><P>You could modify the flag above say for a given holiday similar to:(assumes "year" of data is 2013)</P><P>If date=holiday('easter',2013) then WeekDayFlag=0; /* assuming Easter isn't a day you want counted*/</P></BODY></HTML> Mon, 09 Jun 2014 20:29:45 GMT https://communities.sas.com/t5/SAS-Procedures/Weekdays-in-DATA-SET/m-p/134817#M36525 ballardw 2014-06-09T20:29:45Z