When you run a Base SAS procedure that is enabled for in-database processing against a Snowflake table, the processing might be done completely in SAS instead. This issue occurs when the following are true:

• You access the Snowflake database using SAS/ACCESS^® Interface to Snowflake.
• You run one of the following Base SAS procedures: 
  • FREQ
  • RANK
  • REPORT
  • SORT (with NODUPKEY option)
  • SUMMARY/MEANS
  • TABULATE
• The ROLE= option is defined in both your ODBC data source and the settings in your LIBNAME statement and the settings in the data source are set to different values for the option.

In this scenario, an error similar to the following might appear in the SAS log:

The error is an informational message to notify the user that the push down of the summarization to the database did not occur and that the processing was done in SAS instead. It is not a typical error that sets a nonzero return code.

See SAS Note 67487 for an issue with the DATABASE= option and SAS Note 69766  for an issue with the ROLE= and WAREHOUSE= options.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Snowflake 9.43 is available at:

A fix for this issue for SAS/ACCESS Interface to Snowflake 9.42 is available at: