https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448584#M112852 <P>Finyear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percentage</P><P>20142015&nbsp;&nbsp;&nbsp;&nbsp; 26469&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 421596&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6%</P><P>20142015&nbsp;&nbsp;&nbsp;&nbsp; 370644&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14582164&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2%</P><P>20152016&nbsp;&nbsp;&nbsp; 108747&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 643178&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16%</P><P>20152016&nbsp;&nbsp;&nbsp;&nbsp; 1259525&nbsp;&nbsp;&nbsp;&nbsp; 17519233&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7%</P><P>&nbsp;</P><P>My Query is: I am getting percentage row level wise but when i am trying to sum up finyear wise i.e. vertically</P><P>the value is changing , means i am not getting result after aggregation.</P><P>Kindly provide me solution regarding this.</P><P>&nbsp;</P><P>Regards,</P><P>Harsh Patel</P> Mon, 26 Mar 2018 09:53:22 GMT harsh1 2018-03-26T09:53:22Z https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448584#M112852 <P>Finyear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percentage</P><P>20142015&nbsp;&nbsp;&nbsp;&nbsp; 26469&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 421596&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6%</P><P>20142015&nbsp;&nbsp;&nbsp;&nbsp; 370644&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14582164&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2%</P><P>20152016&nbsp;&nbsp;&nbsp; 108747&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 643178&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16%</P><P>20152016&nbsp;&nbsp;&nbsp;&nbsp; 1259525&nbsp;&nbsp;&nbsp;&nbsp; 17519233&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7%</P><P>&nbsp;</P><P>My Query is: I am getting percentage row level wise but when i am trying to sum up finyear wise i.e. vertically</P><P>the value is changing , means i am not getting result after aggregation.</P><P>Kindly provide me solution regarding this.</P><P>&nbsp;</P><P>Regards,</P><P>Harsh Patel</P> Mon, 26 Mar 2018 09:53:22 GMT https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448584#M112852 harsh1 2018-03-26T09:53:22Z https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448621#M112864 <P>Please post the desired output and code used to calculated the percentages.</P> Mon, 26 Mar 2018 13:08:58 GMT https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448621#M112864 andreas_lds 2018-03-26T13:08:58Z https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448885#M112915 <P>Row level division calculation is possible in EG but we want to show output in SAS VA which should be aggregated but&nbsp; right now it shows the summation of the row level in EG.</P><P>Kindly suggest some solution.</P><P>Finyear&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; income &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; expense&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; expratio</P><P>20142015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Guj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Ahmd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.8</P><P>20142015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Guj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Vadodara &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.75</P><P>20142015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Maharashtra &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mumbai &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 250 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.8</P><P>20142015 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Maharashtra &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pune &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.5</P><P>20152016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Guj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ahmd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.66</P><P>20152016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Guj&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vadodara&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.83</P><P>&nbsp;</P><P>We want to show this data in SAS va.&nbsp; If the user&nbsp; 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.</P><P>&nbsp;</P><P>Thanks,</P><P>Harsh Patel</P> Tue, 27 Mar 2018 07:53:43 GMT https://communities.sas.com/t5/SAS-Programming/Percentage-calculation/m-p/448885#M112915 harsh1 2018-03-27T07:53:43Z