BookmarkSubscribeRSS Feed
Pandu
Fluorite | Level 6

When the month changes, a calendar week can be split into two technical weeks: TWa (part of the week in the previous month) and TWb (part of the week in next month)

 

In a technical week, we would like to separate data based on months.
For example: Transition week - 5th week of 2023 have 2 days from Jan month(30th & 31st) and 5 days from Feb month(1st to 5th)

Pandu_0-1674111516919.png

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.

Pandu_1-1674111923152.png

Please suggest us the appropriate code for the technical week issue.

1 REPLY 1

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 593 views
  • 0 likes
  • 2 in conversation