topic Re: encoding issue while reading sql database in SAS Programming

encoding issue while reading sql database

sangavis37 — Fri, 08 Dec 2023 08:12:41 GMT

When our customer tries to read an sql database that has latin1 characters, in sas (with utf-8 session encoding), it displays question mark in place of those characters. I suggested this https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Windowing-Environment/ta-p/597621 but it did not help. Anyone has any idea how we can resolve this? Thank you in advance.

data xxxx;
set xxxx;
where xx like '%ë%';
run;

Ksharp — Fri, 08 Dec 2023 09:07:30 GMT

Change your SAS encoding to be the same with sql database. Like : WLATIN1

Patrick — Fri, 08 Dec 2023 09:37:55 GMT

sangavis37 — Fri, 08 Dec 2023 13:50:01 GMT

They are using oledb to connect and encoding= option does not seem to available for oledb