topic Re: Thai Language support in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170397#M44037 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>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?&nbsp; </P></BODY></HTML> Wed, 12 Feb 2014 19:02:36 GMT SASKiwi 2014-02-12T19:02:36Z Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170392#M44032 <HTML><HEAD></HEAD><BODY><P>I am accessing a MS SQL table where the customer name is in THAI Language. </P><P></P><P>When I download the data to sas dataset the characters are jumbled up.</P><P></P><P>How to show the Thai Language?</P></BODY></HTML> Tue, 11 Feb 2014 11:06:05 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170392#M44032 hellind 2014-02-11T11:06:05Z Re: Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170393#M44033 <HTML><HEAD></HEAD><BODY><P>Try setting the LOCALE option in a SAS options statement before reading the MS SQL table:</P><P></P><P><A href="http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#p0kcqbj7zsjq23n1lfyrcgtwiy5q.htm">http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#p0kcqbj7zsjq23n1lfyrcgtwiy5q.htm</A></P><P></P><P>Another thought: Thai fonts may need to be installed for the Thai characters to display correctly, like Angsana New for example. </P></BODY></HTML> Tue, 11 Feb 2014 19:12:59 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170393#M44033 SASKiwi 2014-02-11T19:12:59Z Re: Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170394#M44034 <HTML><HEAD></HEAD><BODY><P>I am using SAS 9.2</P><P></P><P>I tried the LOCALE SYSTEM OPTION but it did not work.</P><P></P><P>When you say Thai Fonts needs to be installed, what do you mean? Do I have to install it in windows? </P></BODY></HTML> Wed, 12 Feb 2014 03:15:48 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170394#M44034 hellind 2014-02-12T03:15:48Z Re: Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170395#M44035 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>I also noticed when I export from database to txt file it is garbled but when I export to XLS it is okay.</P></BODY></HTML> Wed, 12 Feb 2014 03:17:49 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170395#M44035 hellind 2014-02-12T03:17:49Z Re: Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170396#M44036 <HTML><HEAD></HEAD><BODY><P>SAS uses NLS, National Language Support, to describe most of the issues around languages.</P><P></P><P>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.</P><P></P><P><BR /> </P></BODY></HTML> Wed, 12 Feb 2014 16:25:42 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170396#M44036 ballardw 2014-02-12T16:25:42Z Re: Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170397#M44037 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>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?&nbsp; </P></BODY></HTML> Wed, 12 Feb 2014 19:02:36 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170397#M44037 SASKiwi 2014-02-12T19:02:36Z Re: Thai Language support https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170398#M44038 <HTML><HEAD></HEAD><BODY><P>In excel the point is ARIAL.</P><P></P><P>I am using BASE SAS 9.2</P></BODY></HTML> Thu, 13 Feb 2014 09:55:29 GMT https://communities.sas.com/t5/SAS-Procedures/Thai-Language-support/m-p/170398#M44038 hellind 2014-02-13T09:55:29Z