Problem Note 70479: Trying to run one of the Base SAS® procedures against a Snowflake table might return 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 might occur when trying to authenticate to the database using OKTA when one of the following procedures is used:
- FREQ
- MEANS/SUMMARY
- REPORT
- SORT (NODUPKEY)
- REPORT
The error is an informational message that the summarization is not being passed to the database. Rather than failing, the procedure still works, but SAS is reading the data from the Snowflake table and doing the processing instead of it happening by the database. This behavior might result in slower performance.
There is no workaround for this issue.
See SAS Note 67487 for an issue with the DATABASE= option, SAS Note 69766 for an issue with the ROLE= and WAREHOUSE= options, and SAS Note 70478 for an issue with the ROLE= option.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Snowflake (on SAS Viya) | Linux for x64 | 2020.0.4 | Stable 2023.08 | Viya platform | Viya platform |
| Microsoft® Windows® for x64 | V.03.04 | Viya | ||||
| SAS System | SAS/ACCESS Interface to Snowflake | Linux for x64 | 9.41 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 9.41 | 9.4 TS1M6 | ||||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2025-04-18 11:49:33 |
| Date Created: | 2023-10-31 08:48:55 |