topic Re: the order week of the Month in SAS Programming https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122037#M293756 <HTML><HEAD></HEAD><BODY><P>The SAS website has a solution for this.</P><P></P><P><A href="http://support.sas.com/kb/41/732.html">http://support.sas.com/kb/41/732.html</A></P></BODY></HTML> Fri, 26 Apr 2013 15:53:08 GMT Keith 2013-04-26T15:53:08Z the order week of the Month https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122036#M293755 <HTML><HEAD></HEAD><BODY><P>I use SAS 9.1.&nbsp; I want to get the order week of the month. such as 1st , 2nd , 3rd week of the month. Could anyone can help me ?</P><P></P><P>For example:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 315px;"><TBODY><TR><TD class="xl67" height="20" width="64">Date</TD><TD class="xl68" width="64">Month</TD><TD class="xl68" width="187"> need : WeeK_num_ of Month</TD></TR><TR><TD align="right" class="xl65" height="20">15-Mar</TD><TD class="xl66">Mar</TD><TD class="xl66">3</TD></TR><TR><TD align="right" class="xl65" height="20">16-Mar</TD><TD class="xl66">Apr</TD><TD class="xl66">3</TD></TR><TR><TD align="right" class="xl65" height="20">17-Mar</TD><TD class="xl66">May</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">18-Mar</TD><TD class="xl66">Jun</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">19-Mar</TD><TD class="xl66">Jul</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">20-Mar</TD><TD class="xl66">Aug</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">21-Mar</TD><TD class="xl66">Sep</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">22-Mar</TD><TD class="xl66">Oct</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">23-Mar</TD><TD class="xl66">Nov</TD><TD class="xl66">4</TD></TR><TR><TD align="right" class="xl65" height="20">24-Mar</TD><TD class="xl66">Dec</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">25-Mar</TD><TD class="xl66">Jan</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">26-Mar</TD><TD class="xl66">Feb</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">27-Mar</TD><TD class="xl66">Mar</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">28-Mar</TD><TD class="xl66">Apr</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">29-Mar</TD><TD class="xl66">May</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">30-Mar</TD><TD class="xl66">Jun</TD><TD class="xl66">5</TD></TR><TR><TD align="right" class="xl65" height="20">31-Mar</TD><TD class="xl66">Jul</TD><TD class="xl66">6</TD></TR><TR><TD align="right" class="xl65" height="20">1-Apr</TD><TD class="xl66">Apr</TD><TD class="xl66">1</TD></TR><TR><TD align="right" class="xl65" height="20">2-Apr</TD><TD class="xl66">May</TD><TD class="xl66">1</TD></TR><TR><TD align="right" class="xl65" height="20">3-Apr</TD><TD class="xl66">Jun</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">4-Apr</TD><TD class="xl66">Jul</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">5-Apr</TD><TD class="xl66">Aug</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">6-Apr</TD><TD class="xl66">Sep</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">7-Apr</TD><TD class="xl66">Oct</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">8-Apr</TD><TD class="xl66">Nov</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">9-Apr</TD><TD class="xl66">Dec</TD><TD class="xl66">2</TD></TR><TR><TD align="right" class="xl65" height="20">10-Apr</TD><TD class="xl66">Jan</TD><TD class="xl66">3</TD></TR><TR><TD align="right" class="xl65" height="20">11-Apr</TD><TD class="xl66">Feb</TD><TD class="xl66">3</TD></TR><TR><TD align="right" class="xl65" height="20">12-Apr</TD><TD class="xl66">Mar</TD><TD class="xl66">3</TD></TR><TR><TD align="right" class="xl65" height="20">13-Apr</TD><TD class="xl66">Apr</TD><TD class="xl66">3</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 26 Apr 2013 15:46:24 GMT https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122036#M293755 QLi 2013-04-26T15:46:24Z Re: the order week of the Month https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122037#M293756 <HTML><HEAD></HEAD><BODY><P>The SAS website has a solution for this.</P><P></P><P><A href="http://support.sas.com/kb/41/732.html">http://support.sas.com/kb/41/732.html</A></P></BODY></HTML> Fri, 26 Apr 2013 15:53:08 GMT https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122037#M293756 Keith 2013-04-26T15:53:08Z Re: the order week of the Month https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122038#M293757 <HTML><HEAD></HEAD><BODY><P>I tried it from the link&nbsp; and worked it out. Thank you very much , Keith.</P></BODY></HTML> Fri, 26 Apr 2013 15:57:32 GMT https://communities.sas.com/t5/SAS-Programming/the-order-week-of-the-Month/m-p/122038#M293757 QLi 2013-04-26T15:57:32Z