Hello There,
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 % base 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% |
