SAS visual analytics without data explorer function ... View more

Thanks Teri, much appreciated your help!   now i have a different question:   I need to create a field of "% base" in SAS VAAR, based on the subtotal of each category. I have three attributes of year_month, Control_ind and program flag. The % of base total will be based on the subtotal of year_month, control_target and program flag as follows.   Could you please suggest how I can do it in SAS VAAR? Many thanks for your help!   year_month CONTROL_IND PROGRAM_FLAG Total % base 201705    N 1A 90806 7.91%     1B 53687 4.68%     1C 20902 1.82%     1D 9580 0.83%     1E 12320 1.07%     2A 98835 8.61%     2B 136771 11.91%     2C 5650 0.49%     2D 47078 4.10%     2E 4326 0.38%     2F 33839 2.95%     3A 252623 22.01%     3B 107777 9.39%     4A 45332 3.95%     5 228406 19.90%   N Total   1147932 100.00% ... View more

Thanks Teri.   i have two questions for you if I may: 1. if i have multiple metrics to compare, for example Sales, revenue and profit, any faster way to do it?   2. If i did transpose first to flip the month to columns, how i can compare the difference of two months? there are two conditions as follows:     a. clients can choose any two months to compare, instead of current and previous month     b. there are multiple metrics restored in a _name_ columns   any help would be much appreciated!   thank you Lilian ... View more

Thanks Teri.   i have two questions for you if I may: 1. if i have multiple metrics to compare, for example Sales, revenue and profit, any faster way to do it?   2. If i did transpose first to flip the month to columns, how i can compare the difference of two months? there are two conditions as follows:  is that the clients can choose any two months to compare, instead of current and previous month, and ... View more