Finyear Value1 value2 Percentage
20142015 26469 421596 6%
20142015 370644 14582164 2%
20152016 108747 643178 16%
20152016 1259525 17519233 7%
My Query is: I am getting percentage row level wise but when i am trying to sum up finyear wise i.e. vertically
the value is changing , means i am not getting result after aggregation.
Kindly provide me solution regarding this.
Regards,
Harsh Patel
Please post the desired output and code used to calculated the percentages.
Row level division calculation is possible in EG but we want to show output in SAS VA which should be aggregated but right now it shows the summation of the row level in EG.
Kindly suggest some solution.
Finyear State City income expense expratio
20142015 Guj Ahmd 100 80 0.8
20142015 Guj Vadodara 200 150 0.75
20142015 Maharashtra Mumbai 250 200 0.8
20142015 Maharashtra Pune 200 100 0.5
20152016 Guj Ahmd 150 100 0.66
20152016 Guj Vadodara 120 100 0.83
We want to show this data in SAS va. If the user does not select any filters the column should show overall expratio, if he selects particular state it should show expratio of that particular state.If they select state and city it should show accordingly.
Thanks,
Harsh Patel
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.