Hi I'm looking to create a new column in the same table like below where the columns are from the same category and value 1 is the numerator and value 2 is the denominator:
| | Category 1 | |
| | Value 1 | Value 2 | New Value (Value 1/Value2) |
| Measure 1 | 1 | 5 | 0.20 |
| Measure 2 | 2 | 6 | 0.33 |
| Measure 3 | 3 | 7 | 0.43 |
| Measure 4 | 4 | 8 | 0.50 |
Thanks.
Update: I'm looking to achieve this under SAS Visual Analytics.