hi KurtBremser, Thank you for your quick response. My SAS sesson encoding is WLATIN1 and i cant use translate as this code should be working dynamically. Also i see one article "The Impact of Change from wlatin1 to UTF-8 Encoding in SAS Environment" suggesting that "DBMS=XLS does not support the multiple-byte characters! Thus, you cannot create (or import) via PROC EXPORT/PROC IMPORT a .XLS file with characters like μ in UTF-8 encoding SAS environment.". So is their a way to import XLS files with special characters with SAS 9.1.3 on unix environment ? Thanks, manjan
... View more