Hello @Ramabc3,
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 @Kurt_Bremser
.Product | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Cur_month | ROY |
A | 1 | 2 | 1 | 4 | 2 | 1 | 1 | 2 | 1 | 1 | 15 |
B | 2 | 3 | 1 | 4 | 2 | 1 | 1 | 2 | 1 | 2 | 17 |
C | 2 | 3 | 1 | 4 | 2 | 1 | 1 | 2 | 1 | 2 | 17 |
D | 2 | 3 | 1 | 4 | 2 | 1 | 1 | 2 | 1 | 2 | 17 |
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.
Thanks
Ramaa
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.