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?
... View more