topic Re: Issue with converting UTF-8 encoded XPT file into SAS dataset in WLATIN1 SAS 9.4 environment in SAS Procedures

Issue with converting UTF-8 encoded XPT file into SAS dataset in WLATIN1 SAS 9.4 environment

sn_1 — Tue, 30 Apr 2024 20:01:56 GMT

Hello,

Can you please suggest if there is a way to convert UTF-8 encoded XPT file into SAS dataset in WLATIN1 SAS 9.4 environment. I have tried many options like ENCODING=ANY . But nothing worked. I encountered below log issue.

I understand UTF-8 is a MBCS where as WALTIN1 is Single Byte Character Set (SBCS). I understand we can change the configuration to UTF-8 to use MBCS data. But is there a way to do this without changing the environment of SAS to read into file.

Thank you much!

Swathi

Re: Issue with converting UTF-8 encoded XPT file into SAS dataset in WLATIN1 SAS 9.4 environment

Tom — Tue, 30 Apr 2024 20:05:52 GMT

This was just asked recently.

https://communities.sas.com/t5/SAS-Programming/Importing-a-wlatin1-XPT-file-on-a-system-running-in-UTF-8/m-p/924976

Re: Issue with converting UTF-8 encoded XPT file into SAS dataset in WLATIN1 SAS 9.4 environment

Ksharp — Wed, 01 May 2024 01:54:43 GMT

You could use UNICODE sas to import this kind of XPT , after that just convert this dataset from utf-8 encoding into WALTIN1 encoding by this URL:

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/nlsref/p1g1d26os4w0von1cdfh827foo3r.htm

Re: Issue with converting UTF-8 encoded XPT file into SAS dataset in WLATIN1 SAS 9.4 environment

Tom — Wed, 01 May 2024 12:24:57 GMT

It matters a lot what type of file your "XPT" file is. The XPT extension has no fixed definition. SAS can create V5 XPORT files using the XPORT libref engine. It can make CPORT files using PROC CPORT. You can even now make a modified/enhanced version of the XPORT file format that supports V7/V8/V9 enhancements to the SAS dataset by using the SAS supplied %LOC2XPT() macro.

So what type of file do you have? If you don't know you can use this macro to test your file:

https://github.com/sasutils/macros/blob/master/xpttype.sas