71029 - The SCANSTRINGCOLUMNS=yes option might not reduce the length of the VARCHAR Data Type Columns in a Snowflake table

Problem Note 71029: The SCANSTRINGCOLUMNS=yes option might not reduce the length of the VARCHAR Data Type Columns in a Snowflake table

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.

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Snowflake	Microsoft® Windows® for x64	9.42		9.4 TS1M7
SAS System	SAS/ACCESS Interface to Snowflake	Linux for x64	9.42		9.4 TS1M7
SAS System	SAS/ACCESS Interface to Snowflake (on SAS Viya)	Linux for x64	Stable 2024.08		Viya

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

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:

Type:	Problem Note
Priority:	high

Date Modified:	2024-11-12 16:19:19
Date Created:	2024-10-31 13:39:44