Hi Techies, Can anyone give me the solution to one of my requirement that i am facing in financial domain in calculating variance and YOY, YTD report in SAS VA. My DATASET contains : Country(char) Rev(INT), SEG(Char), Prod(Char), Reporting Month ( 201501,201502..201610), Dom(INT) etc as variables. Now i need to create summary cross table with variance values on each quarter. Also i had report filters for SEG and Prod. please help me if it is possible in SAS VA. If so guide me on this item also what is the formula to create variance in SAS VA. REV(INT) variable values are used in creating vaariance. Quarter Q1'16 Q2'16 Q1'15 Q2'15 Q1'16 vs Q1'15 Country REV DOM REV DOM REV DOM REV DOM Var$/REV Var%/REV A 491 772 513 784 491 772 491 772 (22) -4% B 65 83 72 88 65 83 65 83 (7) -9% C 42 96 43 112 42 96 42 96 (1) -2% D 14 121 19 153 14 121 14 121 (5) -25% E 30 49 31 50 30 49 30 49 (1) -3% Also How to calculate YOY values for the same. EX. This Values are measured using REV(INT) variable. Q1'15 Q1'16 Q4'15 YoY % 738 736 740 100% Q4'15 Q1'16 YoY $ YoY % 740 736 -4 -1% What is the formula for YOY in SAS VA What is the much difference between YOY calculation and Variance calculation on Same variable? What results we can see. Any solution on these will help me a lot. Thanks
... View more