Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Percentage of Expenses from Total Income: SAS VA

Reply
Frequent Contributor
Posts: 80

Percentage of Expenses from Total Income: SAS VA

[ Edited ]

Hi Community,

 

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?

like: 

% Transit charges from Total Income=? 

% Internet charges from Total Income=? and so on...

 

Regards,

Balraj

 

Occasional Contributor
Posts: 14

Re: Percentage of Expenses from Total Income: SAS VA

Hi

 

Is this your requirement?

 

result.PNG

 

 

 

Frequent Contributor
Posts: 80

Re: Percentage of Expenses from Total Income: SAS VA

[ Edited ]

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:

expen# - Copy.png

Occasional Contributor
Posts: 14

Re: Percentage of Expenses from Total Income: SAS VA

In the pie chart that values are % of total expense and not % of total income, that is why when you total them they give 100%.

 

They are two different calculations isn't it? Not sure if i am missing something.

Occasional Contributor
Posts: 14

Re: Percentage of Expenses from Total Income: SAS VA

Hi

 

In order to get values same as pie chart like:

 

imag2.PNG

 

The calculation:

 

imag3.PNG

 

 

Frequent Contributor
Posts: 80

Re: Percentage of Expenses from Total Income: SAS VA

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 

each group.

Is there any alternate method to achieve the same?

 

Please share some inputs on this.

Ask a Question
Discussion stats
  • 5 replies
  • 222 views
  • 2 likes
  • 2 in conversation