In SAS Size Profiling, SAS Visual Analytics Administration and Reporting reports using size related data fields might have sort order and/or sort option problems due to having STD_SIZE_CD values with data lengths greater than six characters. For example, when the reports contain Size Names or Size Codes, the sort order might not be correct due to usage of STD_SIZE_CD values longer than six characters. Also, the drop-down selection for the Sort Options property Value field might be grayed out and inaccessible if using STD_SIZE_CD values longer than six characters. The STD_SIZE_CD values can be found in both the DI_DM2.STD_SIZE_CD and DI_DM2.SIZE_TRANSLATION tables.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Size Optimization 3.41 is available at:

A fix for this issue for SAS Revenue Optimization 5.4 is available at:

A fix for this issue for SAS Size Optimization 3.4 is available at: