https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46401#M12366 Monday, Tuesday, Wednesday, Thursday, Friday<BR /> it repeats a lot <span class="lia-unicode-emoji" title=":winking_face:">😉</span><BR /> [pre]<BR /> data weekdays;<BR /> do date = '1jan1990'd to '31dec2000'd ;<BR /> w= weekday( date) ;<BR /> if w not in( 1,7) then output ;<BR /> end ;<BR /> stop;<BR /> run ;[/pre] not sure why !<BR /> <BR /> <BR /> Message was edited by: Peter.C Thu, 18 Jun 2009 13:08:36 GMT Peter_C 2009-06-18T13:08:36Z https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46400#M12365 I want to list all weekdays between 2 years say, 19990101 to 20001231<BR /> <BR /> Any one can help me? <BR /> <BR /> Thanks and Regards<BR /> Fred Thu, 18 Jun 2009 13:01:39 GMT https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46400#M12365 Fred_Gavin 2009-06-18T13:01:39Z https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46401#M12366 Monday, Tuesday, Wednesday, Thursday, Friday<BR /> it repeats a lot <span class="lia-unicode-emoji" title=":winking_face:">😉</span><BR /> [pre]<BR /> data weekdays;<BR /> do date = '1jan1990'd to '31dec2000'd ;<BR /> w= weekday( date) ;<BR /> if w not in( 1,7) then output ;<BR /> end ;<BR /> stop;<BR /> run ;[/pre] not sure why !<BR /> <BR /> <BR /> Message was edited by: Peter.C Thu, 18 Jun 2009 13:08:36 GMT https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46401#M12366 Peter_C 2009-06-18T13:08:36Z https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46402#M12367 Thanks so much Thu, 18 Jun 2009 13:15:19 GMT https://communities.sas.com/t5/SAS-Procedures/list-all-weekdays-between-2-years/m-p/46402#M12367 Fred_Gavin 2009-06-18T13:15:19Z