04-19-2018 12:35 AM
04-19-2018 03:03 AM
Your question requires more details before experts can help. Can you revise your question to include more information?
Review this checklist:
To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message. From there you can adjust the title and add more details to the body of the message. Or, simply reply to this message with any additional information you can supply.
SAS experts are eager to help -- help them by providing as much detail as you can.
This prewritten response was triggered for you by fellow SAS Support Communities member @KurtBremser.
04-19-2018 07:05 AM
04-20-2018 07:18 AM
Column Named "Cur_Month" and "ROY" is what I want to calculate.
As I have already mentioned, this table is dynamic...next month I will have data starting from May to Dec, in which case it will have to store May numbers in the Cur_Month and the rest of the months in ROY as a Sum(Jun+July+Aug+Sep+Oct+Nov+Dec)
Please note : I am using SAS Enterprise guide 7.1....I an use the program window to write the code or macro.