02-11-2014 02:12 PM
Try setting the LOCALE option in a SAS options statement before reading the MS SQL table:
Another thought: Thai fonts may need to be installed for the Thai characters to display correctly, like Angsana New for example.
02-11-2014 10:17 PM
It is my first time been asked to work on a database with foreign characters. I will have to read up more on INTERNATIONALIZATION, if this is the term.
I also noticed when I export from database to txt file it is garbled but when I export to XLS it is okay.
02-12-2014 11:25 AM
SAS uses NLS, National Language Support, to describe most of the issues around languages.
The text file viewer/editor likely uses a default font, for example mine is Courier, that interprets a unicode or double byte set incorrectly. XLS does allow additional font information.
02-12-2014 02:02 PM
Thai fonts need to be installed on the computer where Thai characters are to be displayed. The fact that it displays OK in Excel suggests that you do have Thai fonts installed. In the Excel spreadsheet where Thai characters are displaying correctly select a cell with correct Thai characters then check the font Excel is using in the task ribbon. What is the name of the font?
Also how are you viewing the SAS dataset with Thai customer names? Are you using Base SAS or EG as your SAS interface and what version are you using?