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

A fix for this issue for SAS Visual Scenario Designer 6.3_M1 is available at: