topic Re: Invalid characters from Azure Synapse tables in SAS Enterprise Guide

Invalid characters from Azure Synapse tables

AlanCGIC — Thu, 12 Jun 2025 13:52:11 GMT

I use the following libname statement in EG 8.3 when connecting to a schema (ST_DIST) in Azure Synapse:

libname ST_DIST SQLSVR Datasrc=Synapse_PROD_Pool01 SCHEMA=ST_DIST readbuff=32767 insertbuff=32767 User=&azsynusr. Password="&azsynpss" ;

When I browse the tables, there are invalid characters instead of trademark symbols and emdashes.

The collation field for the Azure Synapse tables is set to SQL_Latin1_General_CP1_CI_AS

What do I need to do in SAS to fix this problem?

Re: Invalid characters from Azure Synapse tables

SASKiwi — Thu, 12 Jun 2025 20:43:37 GMT

This is likely caused by an encoding mismatch between Synapse and SAS. I would start by checking the encoding of your SAS session. Please run this and post the results:

proc options option = encoding;
run;

Re: Invalid characters from Azure Synapse tables

AlanCGIC — Thu, 12 Jun 2025 20:59:04 GMT

Here is the current encoding for SAS:

ENCODING=LATIN1