DATA Step, Macro, Functions and more

How to read Spanish accent characters correctly from Oracle database

Reply
Learner
Posts: 1

How to read Spanish accent characters correctly from Oracle database

Hi,

 

I am trying to read in spanish charcaters (for eg: ñeva) from Oracle into unix SAS. I am getting the names in SAS tables as (?eva). It puts a question mark (?) whenever there are accent characters. How can i rectify this? also, is it possible to change the properties of the SAS tables in UNIX ? i want to change the encodign proerties to 'latin1' instead of default. 

 

 

Let me know if you need any additional details.

 

 

Thank you in advance!

Super User
Posts: 10,035

Re: How to read Spanish accent characters correctly from Oracle database

You'd better change your SAS session's encoding too .

 

proc datasets library=work nodetails nolist;
 modify have/ correctencoding='utf8' ;
quit;
Ask a Question
Discussion stats
  • 1 reply
  • 431 views
  • 0 likes
  • 2 in conversation