SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Special char from Oracle in DI Studio

Reply
New Contributor
Posts: 2

Special char from Oracle in DI Studio

[ Edited ]

Hi Team,

 

When I read the data in SAS DI from oracle table which contain ADDRESS  field.Address field contain ¿ this special char.

 

 

.When SAS DI read this value it convert it into ? but we need as it is like ¿.

 

I have take  ¿ this value in work table of SAS DI/SAS EG then it work.But it not work for Oracle table

 

I have also used translate function in  SAS DI but it also not work.

 

If you have any idea /solution then kindly let me know.

 

 

Thanks,

Pankaj Kolhe,

pankajkolhe92@gmail.com

Super User
Posts: 5,494

Re: SAS DI Issue

Posted in reply to pankajkolhe

Sounds like an encoding issue. Compare the encoding in Oracle with the one that your SAS configuration uses.

Also, some viewers might not always display the stored value correctly due to font constraints or other reasons. 

Data never sleeps
New Contributor
Posts: 2

Re: SAS DI Issue

Hi Linush,

 

 

Could you please provide the sample code to handle this situation or give me confirmation that  this data cannot be handled by SAS .

 

I have checked it from my end but it did not work.

 

Could you please provide the encoding solution .

Super User
Posts: 5,494

Re: Special char from Oracle in DI Studio

Posted in reply to pankajkolhe
Character encoding is not a solution, it's something you need to consider.
If you don't have the means to investigate it yourself contact your Oracle DBA and your SAS admin.
Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 155 views
  • 0 likes
  • 2 in conversation