Special char from Oracle in DI Studio

[pankajkolhe]

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

[LinusH]

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. 

[pankajkolhe]

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 .

[LinusH]

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.