Problem Note 58651: SAS® Visual Scenario Designer might calculate an incorrect value for columns in a transformation window
 |  |  |  |  |
In SAS Visual Scenario Designer, when you create a calculated column in a transformation window, the calculation executes correctly within the user interface. However, if the code is exported from SAS Visual Scenario Designer, then the exported calculations are not correct. This error is due to an order-of-execution issue within the exported code. In the SAS code that is generated by the deployment, the calculated columns are reordered into alphabetical order.
There are no errors or warnings to indicate a problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Example:
- Apple = (value*100) / range
- Cherry = 0 - Apple
- Blueberry = max(Apple, Cherry)
In the SAS code that is generated by the deployment, the calculated columns are reordered into alphabetical order:
- Apple = (value*100) ∕ range;
- Blueberry = max(Apple, Cherry);
- Cherry = 0 - Apple;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Scenario Designer | Linux for x64 | 6.3_M1 | 9.4 TS1M3 | ||
A fix for this issue for SAS Visual Scenario Designer 6.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z53.html#58651| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-03-16 10:42:08 |
| Date Created: | 2016-07-20 11:04:16 |