Hello, We are using SAS 9.4 M7 on rhel 7, grid environment. When running below proc sql to pull data from Sybase db, var-1 and var-2 comes out with blank value. When look at variable details in EG table, both var-1 and var-2 has type: Character, length: 1. code proc sql outobs=100; connect to odbc as myconn(datasrc='XYZ' user='user1' password='encryoted-pwd'); create table test1 as select * from connection to myconn ( select var-1 , var-2 , var-3 , var-4 , var-5 from sybase-db-tbl ); disconnect from myconn; quit; odbc details [XYZ] Description=Sybase ODBC Data Source Driver=/path-to-lib/lib/libsybdrvodb.so #Driver=/path-to-lib/lib/libsybdrvodb-sqllen4.so DriverUnicodeType=1 Server=servername.com Port=12345 Database=db_1 UseCursor=1 EnableProcessLicensing=1 sasenv_local LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/path-to-syb/syb/DataAccess64/ODBC/lib export LD_LIBRARY_PATH DRIVER_LIBRARY_PATH=/path-to-syb/syb/DataAccess64/ODBC/lib export DRIVER_LIBRARY_PATH EASYSOFT_UNICODE=YES export EASYSOFT_UNICODE However, when data pull from different tool, var-1 and var-2 has values like below (example). var-1 ABC DEF GHI JKL var-2 DDF FGH JKL 175
... View more