Problem Note 67487: Trying to run one of the Base procedures against a Snowflake table might result in the message "ERROR: Requested function not supported"
 |  |  |  |  |
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 DATABASE= or DB= option and one of the following procedures is being used:
- FREQ
- MEANS/SUMMARY
- REPORT
- SORT (NODUPKEY)
- REPORT
See SAS Note 69766 for similar issue with the ROLE= or WAREHOUSE= option.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Snowflake | Linux for x64 | 9.4 | 9.4 | 9.4 TS1M6 | 9.4 TS1M8 |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Snowflake 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9Y.html#67487| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-12-19 15:58:47 |
| Date Created: | 2021-02-24 12:23:22 |