Problem Note 53068: "ERROR: The ID value 'DIST_SG_0' occurs twice in the same BY group" might occur when you are using store grouping rules
 |  |  |  |  |
The following error might occur when you attempt to manually create store groups using store grouping rules in SAS® Size Profiling:
ERROR: The ID value "DIST_SG_0" occurs twice in the same BY group. NOTE: The above message was for the following BY group: PROD_LVL=1 PROD_HIER_SK=1 ERROR: The ID value "DIST_SG_0" occurs twice in the same BY group. NOTE: The above message was for the following BY group: PROD_LVL=2 PROD_HIER_SK=4 ...... ERROR: All BY groups were bad. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 24 observations read from the data set THRD_LIB.TMP_DISTMAP. WARNING: The data set THRD_LIB.TMP_DISTMAP_XPOSE may be incomplete. When this step was stopped there were 0 observations and 0 variables.
There are no workarounds for this issue.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#53068| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-02-28 13:24:18 |
| Date Created: | 2014-05-28 09:32:08 |