Proc SQL Encoding Error (how to use subchar to fix it?)

[lhpm2024]

I was trying to create a table that may contain some special characters, which keeps resulting in the error: ERROR: Open error: Failed to transcode result set data in column 'X', row 296, to SESSION encoding. Use the SUBCHAR= LIBNAME/DATA SET option to resolve transcoding issues.

Following are the codes I used to create the table. I have tried to add (SUBCHAR=UESC) to the create table line but it's not working. I'm sure that the issue is coming from the column containing some special characters or punctuations, but have no idea how to do the configuration on SAS.

I don't mind simply ignoring those special characters, but right now the whole table cannot be created because of that error. Any help is appreciated!

Proc SQL;
CONNECT TO HADOOP(SERVER="...");
create table work.Temp as
SELECT *
FROM CONNECTION TO HADOOP
(
these are the simple select * from * SQL codes that can be ignored
)
;
disconnect from Hadoop;
quit;

[SASKiwi]

Please post your complete SAS log where you are using the SUBCHAR option, including the source code and any notes and errors.

Note, you need to be using SAS 9.4M7 or later to use SUBCHAR with Hadoop.