Reducing the lengths of the VARCHAR data type columns in a Snowflake table might not occur when the following are true:

• You are running SAS^® 9.4M7 (TS1M7) with Hot Fix L2C008, SAS^® 9.4M8 (TS1M8) with Hot Fix L9B007, or the SAS^® Viya^® Platform Stable 2024.08 or a later cadence.
• You are using the SCANSTRINGCOLUMNS=YES LIBNAME or DATA step option
• You are using the SQL procedure, and your query contains the DISTINCT argument.
• Your Snowflake table contains more than one column.

There is no workaround for the issue.

See SAS Note 70901 for the original issue with the SCANSTRINGCOLUMNS option not reducing the length. 

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: