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"

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.

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.

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Size Profiling	Microsoft® Windows® for x64	3.41		9.4 TS1M5
SAS System	SAS Size Profiling	Linux for x64	3.41		9.4 TS1M5
SAS System	SAS Pack Optimization	Linux for x64	3.41		9.4 TS1M4
SAS System	SAS Pack Optimization	Microsoft® Windows® for x64	3.41		9.4 TS1M4
SAS System	SAS Promotion Optimization	Microsoft® Windows® for x64	5.4		9.4 TS1M5
SAS System	SAS Promotion Optimization	Linux for x64	5.4		9.4 TS1M5
SAS System	SAS Markdown Optimization	Microsoft® Windows® for x64	5.4		9.4 TS1M5
SAS System	SAS Markdown Optimization	Linux for x64	5.4		9.4 TS1M5
SAS System	SAS Regular Price Optimization	Microsoft® Windows® for x64	5.4		9.4 TS1M5
SAS System	SAS Regular Price Optimization	Linux for x64	5.4		9.4 TS1M5

* 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.

A fix for this issue for Base SAS 9.4_M5 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.41 is available at:

Type:	Problem Note
Priority:	alert

Date Modified:	2018-07-13 08:55:01
Date Created:	2018-05-03 13:22:29