We have a new SAS installation. SAS are in UTF-8 on our Solaris Server, OS is UTF-8 too. When we connect to Sybase or DB2, on data with special characters (ex: á, ñ ) appear wrong. The data is OK on our database.
We had similar problem with SQL Server, but we fixed adding a encoding information on ODBC.ini file.
Hello @MariaD ,
Besides the encoding, I would check the language configuration. DFLANG is a variable that is used to correct the correct language for the data. https://support.sas.com/publishing/pubcat/chaps/59099.pdf
What is the SAS/ACCESS module and the driver you are using for Sybase? And the version of SAS and the version of the driver?
Do you have other SAS installations connecting to those Sybase databases?
How do you receive these visualization errors? SAS EG? SAS DI? SAS Foundation?
OK interesting. A few things.
1- wlatin1 is not a language, it is an encoding. Actually, single-byte, vs the double-byte of UTF-8. This means that what SAS receives or sends is not UTF-8 as you would expect. I would focus on this investigation path as it might be reason, if the something in between is translating from UTF8 to Wlatin1.
2- About DFLANG, please check the language in your database, and in your SAS session. And adjust both and the DFLANG.
3- Check out this hotfix http://ftp.sas.com/techsup/download/hotfix/HF2/D9R_wx6.html
4- As I heard you have SAS/ACCESS to ODBC, fust for fun and giggles, you could try to set up an ODBC connection to Sybase and see how it goes.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.