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)
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.
Please suggest us the appropriate code for the technical week issue.
Post example data in a data step with datalines, not in pictures.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.