I'm using SAS VA 7.2 my sample data is as follows:
Type ItemName Value
Income Services 25000
Income interest received 46500
Income interest -banks 32000
Expense Transit charges 23000
Expense Internet charges 9000
Expense Audit Fees 6000
Expense Bank charges 11000
How can I calculate Percentage of each Expense from Total Income?
% Transit charges from Total Income=?
% Internet charges from Total Income=? and so on...
Yes Spot on..!!! @ShivamKS,
I've implemented till what you've implemented, was about to update that.
Now I'm struck at this point, let me explain:
let suppose sum percent expenses of income =47.35
where as what i'm trying to achieve is it should be equal to 100% of expenses
i.e., sum percent expenses of income = 100% = Total Expenses %
This is what i'm able to achieve:
Wow Thank you very much @ShivamKS now I've understood how it is working internally.
And I've also understood that SUM of % of Expense from Total Income will not be equal to 100%, as it is calculating separately for
Is there any alternate method to achieve the same?
Please share some inputs on this.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.