Hello everyone, Can anybody tell me how to calculate YTD in SAS VA starting from April month till March as per indian fiscal year. Regards, Harsh Patel
... View more
Hi Everyone, I want bottom rank based on conditional parameter in SAS VA 7.3 for instance suppose if i will enter value more than 500 than the list table should reflect the value greater than parameter and apart from that i want bottom 5 ranks based on that parameter only.So if there are 10 rows which would reflect data but i need bottom 5 only based on above parameter hence not considering rows below 500. Kindly suggest me a solution. Regards, Harsh Patel.
... View more
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
... View more
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
... View more
I have a 6 list controls in my report viz. finyear,schemetype,schemedesc,state,brand,variety. Suppose if i select one year with one schemetype and schemedesc, the multiple states data should reflect and if there is only one state will fall under this category it should not be show in report. And same should be applicable in cross tab also. Regards, Harsh Patel.
... View more