Hi All,
I have a web report where the source is OLAP Cube. And day wise records will be appended. For example, If I open the web report today, I should see the data which will be available upto yesterday.
Problem encountered:
I want to write logic for one column, for this here is the below condition:
Columns: Date, W, X, Y, Z
Logic to be developed:
Once I open the report it should prompt me for the date.
1. Scenario: If I enter 5th of current month, it should divide "X" column values divided by 10 and multiplied by 5. Then that value should store in "Z" column.
2. Scenario: If I enter 13th of current month, it should store the value which is there in point no 1(mentioned above) i.e., first 10 days of current month + 2 days i.e., 11th and 12th of the current month.
Please guide me. Thank you in advance..!
Regards,
Sundeep
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.
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.