Dear all, I'm trying to understand and solve a problem I have with SAS, desktop version, 9.4 I accessing a Postgres database (db encoding is UTF-8) with SAS with Proc SQL through the ODBC engine. I use SAS in Unicode and the datafiles that are being created are in UTF-8 unicode format. One of the lines in the result set I get back show the white question mark in a black diamond shape instead of bullet points. This is the code libname sql_read odbc dsn=datasource schema=schemaAB;
PROC SQL;
CREATE TABLE work.test (encoding='UTF-8') as
SELECT id, result
FROM sql_read.tableA
where id = '123'
;
QUIT; The log is clean, it doesn't see anything about truncation For trouble shooting I checked other tools to see what the result is there: Python, and MS Access using the same Odbc data source as SAS and show the bullet points. So I think this is something SAS specific, but I don't know what. I tried to use several encoding settings I found but nothing helps. Does anyone have an idea what this might be? The bullet point in this case might just be one example, I have other tables that I just didn't check yet. Thanks!
... View more
