I hit error when I run a job in SAS DI Studio. The transformation it does is to modify the data inside this table. This table is DIM.ACCOUNT_DIM
If I run the libname statement for DIM, I can see the table and its data in SAS EG. However, when i try to run the job, it has error message:
ERROR: File DIM.ACCOUNT_DIM cannot be updated because its encoding does not match the session encoding or the file is in a format native to another host, such as WINDOWS_64.
In another thread here, there was a guide provided below:
https://blogs.sas.com/content/sasdummy/2010/05/24/finding-the-foreigners-in-your-sas-environment/
However, the guide didn't provide solution.
I would not prefer to create a new library or create a table with a different name because this table has many dependencies.
I've also done some checking. The encoding for DIM.ACCOUNT_DIM is wlatin1_Western (Windows) whereas my server encoding is UTF-8.
How can i fix this without dumping the original table?