Preserve_tab_name did not help - it is yes per default, if i set it to no, the table does not appear anymore. I exported the SAS Dataset with the Tablename into a hex-reader. Looks interesting, SAS really seems to fill in Hex-Code "20" what is in UTF-16le " " 00000000h: FF FE 6D 00 65 00 6D 00 6E 00 61 00 6D 00 65 00 ; ÿþm.e.m.n.a.m.e. 00000010h: 0D 00 0A 00 54 00 20 00 5F 00 20 00 46 00 20 00 ; ....T. ._. .F. . 00000020h: 5F 00 20 00 45 00 20 00 42 00 20 00 4F 00 20 00 ; _. .E. .B. .O. . 00000030h: 58 00 20 00 0D 00 0A 00 0D 00 0A 00 ; X. ......... ... View more

I have validated the table name in the SQL Studio. It is "T_F_EBOX" without spaces. Using the Microsoft ODBC Driver returns the tablenames vertical. I have written them into "want" again - showing only the first letter   Using the DataDirect Driver returns ERROR: CLI cursor fetch error: [DataDirect][ODBC 20101 driver]2713SQL Server ODBC driver2726SQL Server ODBC driver. : [DataDirect][ODBC 20101 driver]2728 Cant find any information to this error "2728" so right now DataDirect does not work.   ... View more

@SASKiwi  I had the same problem in the past when we tried to use SAS CPM on linux. So yes - we have this problem with all MSSQL tables that are connected via ODBC on Linux. When I use the local SAS Server with the odbc-connection defined in the ODBC Admin, I dont have the problem with the incorrect tablename but still have to problem with the encoding-problem utf-8 and utf-16le. The Driver Name on Linux is "libmsodbcsql-13.1.so.9.2" - should be the "Microsoft ODBC Driver 13.1 for SQL Server". I also have a DataDirect Driver, but in this case - even with SCHEMA definied, I got no table returned. ... View more

Specifying the schema helped - sorry I dont do that much SAS programming. So now, I have the dataset - you an see the MouseOver shows only "T" if I doubleclick it to edit the field I can only see "T" too. And this is  how the Library looks like now. This is the same behaviour I have when I use register table in SMC - I get an error that "T" could not be registered. Any ideas how we can force SAS to use the right encoding or remove the blanks before going on? ... View more

Any Idea which setting might help? There is no real documentation for the settings of the Microsoft driver. ... View more

No, no tables ... View more

Hm. Created with 0 Rows 😞 ... View more

It's a readonly database, so I guess, this will not work, right? ... View more

It is utf-8 encoded.  Problem occurs against local server and remote Group=LANGUAGECONTROL DATESTYLE=DMY Specifies the sequence of month, day, and year when ANYDTDTE, ANYDTDTM, or ANYDTTME informat data is ambiguous. DFLANG=GERMAN Specifies the language for international date informats and formats. DSCAS Runs the DATA step on the CAS server. EXTENDOBSCOUNTER=YES Specifies whether to extend the maximum number of observations in a new SAS data file. LOCALEDATA=SASLOCALE Specifies the location of the locale database. LOGLANGCHG Enables changing the language of the SAS log when the LOCALE= option is changed. NOLOGLANGENG Write SAS log messages based on the values of the LOGLANGCHG, LSWLANG=, and LOCALE= options when SAS started. LSWLANG=LOCALE Specifies the language for SAS log and ODS messages when the LOCALE= option is set after SAS starts. MAPEBCDICTOASCII= Specifies the transcoding table that is used to convert characters from ASCII to EBCDIC and EBCDIC to ASCII. NONLDECSEPARATOR Disables formatting of numeric output using the decimal separator for the locale. ODSLANGCHG Enables the language of the SAS message text in ODS output to change when the LOCALE option is set after start up. PAPERSIZE=A4 Specifies the paper size to use for printing. RSASIOTRANSERROR Displays a transcoding error when illegal values are read from a remote application. TIMEZONE="GMT+01:00" Specifies a time zone. TRANTAB= Specifies the translation table catalog entries. URLENCODING=SESSION Specifies whether the argument to the URLENCODE function and to the URLDECODE function is interpreted using the SAS session encoding or UTF-8 encoding. DBCS Enables double-byte character sets for encoding values that support East Asian languages. 2 Das SAS System Freitag, 29. Januar 2021 10:15:00 DBCSLANG=UNKNOWN Specifies a double-byte character set language. DBCSTYPE=UTF8 Specifies the encoding method that is used for a double-byte character set. FSDBTYPE=DEFAULT Specifies a full-screen double-byte character set (DBCS) encoding method. FSIMM= Specifies input method modules (IMMs) for full-screen double-byte character sets (DBCS). FSIMMOPT= Specifies options for input method modules (IMMs) that are used with a full-screen double-byte character set (DBCS). ENCODING=UTF-8 Specifies the default character-set encoding for the SAS session. LOCALE=DE_DE Specifies a set of attributes in a SAS session that reflect the language, local conventions, and culture for a geographical region. NONLSCOMPATMODE Encodes data using the SAS session encoding. ... View more

Didn't know that - but just tried it, does not change anything. The error keeps to be the transcode problem between utf-16le and utf-8 ... View more

Sure 1 Das SAS System Freitag, 29. Januar 2021 10:15:00 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Programm'; 4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported 21 ENCODING='utf-8' 22 STYLE=HtmlBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 options validmemname=extend; 29 LIBNAME ebox2 ODBC DS=H25_EBOX USER=IT25_TATMHIST_XXXX PASSWORD=XXXXXXXXXXXXXXXXXXXXXXX; NOTE: Libref EBOX2 was successfully assigned as follows: Engine: ODBC Physical Name: H25_EBOX 30 proc sql; 31 select memname 32 from dictionary.tables where libname='ebox2'; NOTE: No rows were selected. 33 quit; NOTE: Verwendet wurde: PROZEDUR SQL - (Gesamtverarbeitungszeit): real time 0.00 seconds cpu time 0.00 seconds 34 35 36 %LET _CLIENTTASKLABEL=; 37 %LET _CLIENTPROCESSFLOWNAME=; 38 %LET _CLIENTPROJECTPATH=; 39 %LET _CLIENTPROJECTPATHHOST=; 40 %LET _CLIENTPROJECTNAME=; 41 %LET _SASPROGRAMFILE=; 42 %LET _SASPROGRAMFILEHOST=; 43 44 ;*';*";*/;quit;run; 45 ODS _ALL_ CLOSE; 46 47 48 QUIT; RUN; 2 Das SAS System Freitag, 29. Januar 2021 10:15:00 49   options validmemname=extend; LIBNAME ebox2 ODBC DS=H25_EBOX USER=IT25_TATMHIST_XXXXX PASSWORD="XXXXXXXXXX"; proc sql; select memname from dictionary.tables where libname='ebox2'; quit;   This is the configuration in odbc.ini   [H25_EBOX] Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2 DriverUnicodeType=1 Server=vdb01234,1234 Database=IT25_TATMHIST AutoTranslate=no AnsiNPW=yes   ... View more

Results in this pretty long error message and      And Log says "No rows were selected". The library also does not show any tables ... View more