Hi ,
I am trying to append data from a SAS table to an external postgres table using the append procedure.
However while running the proc, I am getting the error "ERROR: CLI execute error: Error: invalid byte sequence for encoding "UTF8": 0xe2 0x2c 0x55"
Any idea how I can resolve this error?
Thanks and Regards,
Mohammad Umair Kazi
My first guess would be that you try to ingest UTF8 data in a non UTF8 DB.
Check your database what encoding it uses (and compare with your SAS encoding).
Hi ,
I have checked the encoding it is UTF8.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.