Question: The table has material requirement from Dec2022 to Aug2023. If the previous month has Zero material requirement, split the material count accordingly among previous months. The source and required target table as below. Looking for SAS Base code. Thanks in Advance! Date Material Requirement Date Material Requirement 01Dec2022 AA 0 01Dec2022 AA 42 01Jan2023 AA 84 01Jan2023 AA 42 01Feb2023 AA 0 01Feb2023 AA 43 01Mar2023 AA 0 01Mar2023 AA 43 01Apr2023 AA 129 01Apr2023 AA 43 01May2023 AA 0 01May2023 AA 0 01Jun2023 AA 0 01Jun2023 AA 0 01Jul2023 AA 0 01Jul2023 AA 0 01Aug2023 AA 0 01Aug2023 AA 0 01Dec2022 BBB 0 ===>>>> 01Dec2022 BBB 114 01Jan2023 BBB 228 01Jan2023 BBB 114 01Feb2023 BBB 1625 01Feb2023 BBB 1625 01Mar2023 BBB 1651 01Mar2023 BBB 1651 01Apr2023 BBB 2059 01Apr2023 BBB 2059 01May2023 BBB 2075 01May2023 BBB 2075 01Jun2023 BBB 2189 01Jun2023 BBB 2189 01Jul2023 BBB 0 01Jul2023 BBB 0 01Aug2023 BBB 0 01Aug2023 BBB 0 01Dec2022 CC 0 01Dec2022 CC 22 01Jan2023 CC 0 01Jan2023 CC 22 01Feb2023 CC 0 01Feb2023 CC 22 01Mar2023 CC 88 01Mar2023 CC 22 01Apr2023 CC 0 01Apr2023 CC 13 01May2023 CC 0 01May2023 CC 13 01Jun2023 CC 0 01Jun2023 CC 13 01Jul2023 CC 0 01Jul2023 CC 13 01Aug2023 CC 65 01Aug2023 CC 13 01Dec2022 DDD 0 01Dec2022 DDD 33 01Jan2023 DDD 0 01Jan2023 DDD 33 01Feb2023 DDD 0 01Feb2023 DDD 33 01Mar2023 DDD 0 01Mar2023 DDD 33 01Apr2023 DDD 0 01Apr2023 DDD 33 01May2023 DDD 200 01May2023 DDD 33 01Jun2023 DDD 0 01Jun2023 DDD 0 01Jul2023 DDD 0 01Jul2023 DDD 0 01Aug2023 DDD 0 01Aug2023 DDD 0
... View more