https://communities.sas.com/t5/SAS-Programming/Transition-months-in-a-technical-week/m-p/854504#M337707 <P><SPAN>When the month changes, a calendar week can be split into two technical weeks:&nbsp;</SPAN><STRONG>TWa (part of the week in the previous month) and TWb (part of the week in next month)</STRONG></P><P>&nbsp;</P><P>In a technical week, we would like to separate data based on months.<BR />For example: Transition week - 5th week of 2023 have 2 days from Jan month(30th &amp; 31st) and 5 days from Feb month(1st to 5th)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pandu_0-1674111516919.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/79510i43CD2105A7806EA9/image-size/medium?v=v2&amp;px=400" role="button" title="Pandu_0-1674111516919.png" alt="Pandu_0-1674111516919.png" /></span></P><P>Data needs to be separated based on week along with month but should not aggregate the whole week data in a transition week as shown below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pandu_1-1674111923152.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/79511i89A2DD11852956F2/image-size/medium?v=v2&amp;px=400" role="button" title="Pandu_1-1674111923152.png" alt="Pandu_1-1674111923152.png" /></span></P><P>Please suggest us the appropriate code for the technical week issue.</P> Thu, 19 Jan 2023 07:11:42 GMT Pandu 2023-01-19T07:11:42Z https://communities.sas.com/t5/SAS-Programming/Transition-months-in-a-technical-week/m-p/854504#M337707 <P><SPAN>When the month changes, a calendar week can be split into two technical weeks:&nbsp;</SPAN><STRONG>TWa (part of the week in the previous month) and TWb (part of the week in next month)</STRONG></P><P>&nbsp;</P><P>In a technical week, we would like to separate data based on months.<BR />For example: Transition week - 5th week of 2023 have 2 days from Jan month(30th &amp; 31st) and 5 days from Feb month(1st to 5th)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pandu_0-1674111516919.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/79510i43CD2105A7806EA9/image-size/medium?v=v2&amp;px=400" role="button" title="Pandu_0-1674111516919.png" alt="Pandu_0-1674111516919.png" /></span></P><P>Data needs to be separated based on week along with month but should not aggregate the whole week data in a transition week as shown below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pandu_1-1674111923152.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/79511i89A2DD11852956F2/image-size/medium?v=v2&amp;px=400" role="button" title="Pandu_1-1674111923152.png" alt="Pandu_1-1674111923152.png" /></span></P><P>Please suggest us the appropriate code for the technical week issue.</P> Thu, 19 Jan 2023 07:11:42 GMT https://communities.sas.com/t5/SAS-Programming/Transition-months-in-a-technical-week/m-p/854504#M337707 Pandu 2023-01-19T07:11:42Z https://communities.sas.com/t5/SAS-Programming/Transition-months-in-a-technical-week/m-p/854509#M337709 <P>Post example data in a data step with datalines, not in pictures.</P> Thu, 19 Jan 2023 08:09:48 GMT https://communities.sas.com/t5/SAS-Programming/Transition-months-in-a-technical-week/m-p/854509#M337709 Kurt_Bremser 2023-01-19T08:09:48Z