Running one of the Base SAS procedures that is enabled for in-database processing against a Snowflake table might result in the following error:

The error is an informational message to the user that the summarization is not being passed to the database. Instead of failing, the procedure should still work; but, instead SAS is reading the data from the Snowflake table and doing the processing. This behavior might result in slower performance than if the summarization had been done by the database. 

The error might occur when the LIBNAME statement contains the ROLE= or WAREHOUSE= option and you use one of the following procedures:

• FREQ
• MEANS/SUMMARY
• REPORT
• SORT (NODUPKEY)
• REPORT

To work around the issue, you can do one of the following:

• Specify the ROLE or WAREHOUSE option in the CONOPTS= LIBNAME option.
• Grant the user's default role to PUBLIC. 
• Add the ROLE or WAREHOUSE option to the DSN in the odbc.ini file.

See SAS Note 67487 for similar issue with the DATABASE= option, SAS NOTE 70478 for an issue with the ROLE= option, and SAS NOTE 70479 for an issue with the OKTA authentication.

Click the Hot Fix tab in this note to access the hot fix for this issue.

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: