I want to extract data from a Microsoft Access database table and get, when opening the table in SAS Enterprise Guide, the error message “... unable to transcode data to/from UCS-2 encoding”. The SAS Enterprise Guide, version 7.15 HF3 (7.100.5.6132) (64-Bit), runs on Linux, the Microsoft Access database is connected with LIBNAME PCFILES and is password protected. The libname statement works well and after processing the libname the tables of the Microsoft Access database are visible in the SAS Enterprise Guide (below left, server tab). The reason for the error is the usage of three points (“…”) in a row in one of the columns of the tables in the Microsoft Access database, which Microsoft Access converts automatically to a single sign, called horizontal ellipsis. If the column is removed from the corresponding table before processing in SAS Enterprise Guide, the error message does not appear and the data can be extracted. But it is desired to take all the columns from the table in MS Access. MS Access runs on Windows Terminal Sever (thin client). Code for libname LIBNAME <name> PCFILES SERVER="<ip address>" SERVERUSER="<user key>" SERVERPASS="<user pw>" PATH="<path in windows>\<database name>.accdb" PASS="<database pw>"; To change the encoding of SAS (LATIN 9 to UTF-8) is not an option. To use Proc Import instead of LIBNAME PCFILES shows the same error message. Does anyone have a good idea for another option to solve this problem?
... View more