When using the SAS® Merchandise Intelligence %DI_UTIL_SUBSET_DATAMART macro to create a data mart subset, errors similar to the following appear in the log if the IGNORE_TABLE option is specified:
Table: ALLOWED_PRICE_CHG_DATE ERROR: The following columns were not found in the contributing tables: TABLE_NAME. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.00 seconds
A data mart subset is not generated.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
SAS System | SAS Size Profiling | Linux for x64 | 3.2 | 9.3 TS1M2 | ||
Microsoft® Windows® for x64 | 3.2 | 9.3 TS1M2 | ||||
SAS System | SAS Pack Optimization | Linux for x64 | 3.2 | 9.3 TS1M2 | ||
Microsoft® Windows® for x64 | 3.2 | 9.3 TS1M2 | ||||
SAS System | SAS Retail Forecasting | Linux for x64 | 5.2 | 9.3 TS1M2 | ||
Microsoft® Windows® for x64 | 5.2 | 9.3 TS1M2 | ||||
SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |