SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 55901: %DI_UTIL_SUBSET_DATAMART might generate "ERROR: The following columns were not found in the contributing tables: TABLE_NAME."

DetailsHotfixAboutRate It

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.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.25.49.3 TS1M29.4 TS1M3
Linux for x645.25.49.3 TS1M29.4 TS1M3
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.25.49.3 TS1M29.4 TS1M3
Linux for x645.25.49.3 TS1M29.4 TS1M3
SAS SystemSAS Size ProfilingLinux for x643.29.3 TS1M2
Microsoft® Windows® for x643.29.3 TS1M2
SAS SystemSAS Pack OptimizationLinux for x643.29.3 TS1M2
Microsoft® Windows® for x643.29.3 TS1M2
SAS SystemSAS Retail ForecastingLinux for x645.29.3 TS1M2
Microsoft® Windows® for x645.29.3 TS1M2
SAS SystemSAS Regular Price OptimizationLinux for x645.25.49.3 TS1M29.4 TS1M3
Microsoft® Windows® for x645.25.49.3 TS1M29.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.