SUPPORT / SAMPLES & SAS NOTES
Problem Note 62267: ETL jobs in the SAS® Merchandise Intelligence Suite might fail with "ERROR: File does not exist" and "Statement not executed due to NOEXEC option"
 |  |  |  |  |
In the SAS Merchandise Intelligence Suite, ETL jobs might fail with the following errors and messages:
ERROR: File <filename> does not exist
NOTE: Statement not executed due to NOEXEC option.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The SAS System stopped processing this step because of errors.
This issue occurs because one or more PROC SQL calls use the "OPTIONS OBS=0" statement.
Contact SAS Technical Support for assistance in working around 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.41 | 9.4 TS1M5 | ||
| Linux for x64 | 3.41 | 9.4 TS1M5 | ||||
| SAS System | SAS Pack Optimization | Linux for x64 | 3.41 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 3.41 | 9.4 TS1M4 | ||||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M5 | ||
| Linux for x64 | 5.4 | 9.4 TS1M5 | ||||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M5 | ||
| Linux for x64 | 5.4 | 9.4 TS1M5 | ||||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M5 | ||
| Linux for x64 | 5.4 | 9.4 TS1M5 | ||||