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.