DATA Step, Macro, Functions and more

Reading Thailand Characters from Teradata

Reply
New Contributor
Posts: 2

Reading Thailand Characters from Teradata

Data extracted from Teradata using SAS which contains Thailand traditional characters for customer name and displayed as ??.

But when the same data is pulled directly using TD SQL Assistant. I am getting Thailand characters, where I changed the font to UTF8.
How do I fix this issue of Thailand character display in SAS. I tried using encoding=utf8, but thats not working.

Please help me on this.

 

Thanks

Super Contributor
Posts: 266

Re: Reading Thailand Characters from Teradata

Posted in reply to Prem_Ezekiel

I am not sure of my answer. Try it yourself. Apply the below option, see if it works.

 

option LOCALE=th_TH;

 

 

 

New Contributor
Posts: 2

Re: Reading Thailand Characters from Teradata

I tried with locale=th_TH option. But it is not working.

 

Thanks.

 

Occasional Contributor
Posts: 9

Re: Reading Thailand Characters from Teradata

Posted in reply to Prem_Ezekiel

Try:

 

encoding=utf-8

Super User
Posts: 10,035

Re: Reading Thailand Characters from Teradata

Posted in reply to Prem_Ezekiel
That is because the encoding of Teradata is different with your SAS encoding.

modify the file sasenv_local (is under the fold of SAS) , add the correct(Teradata) encoding in it .

and restart SAS .
Ask a Question
Discussion stats
  • 4 replies
  • 316 views
  • 0 likes
  • 4 in conversation