11-27-2017 06:11 AM - last edited on 11-27-2017 06:45 AM by LinusH
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.
11-27-2017 06:42 AM
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.
11-28-2017 01:09 AM
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 .
11-28-2017 02:17 AM