topic Re: Special char from Oracle in DI Studio in SAS Data Management

Special char from Oracle in DI Studio

pankajkolhe — Mon, 27 Nov 2017 11:45:12 GMT

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

Re: SAS DI Issue

LinusH — Mon, 27 Nov 2017 11:42:51 GMT

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.

Re: SAS DI Issue

pankajkolhe — Tue, 28 Nov 2017 06:09:46 GMT

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 .

Re: Special char from Oracle in DI Studio

LinusH — Tue, 28 Nov 2017 07:17:09 GMT

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.