topic Re: XPT file encoded in UTF-8 in SAS Programming

XPT file encoded in UTF-8

sandyming — Tue, 02 Jul 2013 00:24:32 GMT

Is there a way that I can read/copy/import xpt file which has encoding='UTF-8'?

Thanks for your help.

Re: XPT file encoded in UTF-8

Ksharp — Tue, 02 Jul 2013 01:09:52 GMT

No. actually xpt file is a binary file which used to transfer dataset from a computer to another computer.

Why not import xpt file by proc copy +libname xpt engine and use dataset option encode='utf-8' to transform it ?

Ksharp

Re: XPT file encoded in UTF-8

sandyming — Tue, 02 Jul 2013 17:30:47 GMT

Hi Kshap,

Thanks for your help.

I used the proc imcport in my program, and batch ran the program with SAS (UTF-8) instead of SAS.

Sandy

Re: XPT file encoded in UTF-8

Tom — Wed, 03 Jul 2013 02:45:40 GMT

If you have a PROC CPORT generated transport file then you must read it using a SAS session that is running using UTF-8 encoding. You cannot switch on the fly to UTF-8 just to read the transport file.

I have no idea what SAS would do with a V5 Transport file with UTF-8 encoding, but I suspect that the same issues would apply.