Technical question about XPT files

martinc — Mon, 28 May 2012 08:46:37 GMT

Hi, first of all apologies if this isn't the right forum, none of them really seemed to fit!

I need to create XPT files in a third-party application for consumption by SAS, and I have been given an example SAS XPT file which contains Unicode text. This appears to be encoded using UTF-8, although the specification for the XPT format indicates that text should be ASCII only (http://support.sas.com/techsup/technote/ts140.html).

Does anybody know if this is a recent update to the XPT format, and if there is any technical information about it (e.g. is there a flag in the file to indicate the text encoding)?

I have found that SAS UniViewer 1.2 is not able to display the UTF-8 text. I believe SAS 9.2 / 9.3 is able to handle it, however.

Many thanks for any help,

Martin.

Re: Technical question about XPT files

SASKiwi — Mon, 28 May 2012 22:40:01 GMT

The following link will be of use:

http://support.sas.com/techsup/technote/ts140.html

A SAS XPT or XPORT file is also called a SAS transport file and is a way of moving SAS data and other types of SAS files between SAS installations with different versions and/or different operating systems. It is not normally used to move data between third-party applications and SAS because there are far easier ways to do it, For example ODBC, OLEDB, CSV etc.

As the above link suggests trying to reproduce a SAS transport file for a SAS dataset (table) is not straightforward at all. I am curious to know why you have been asked to move data this way. What is the application the data is being sourced from?

topic Re: Technical question about XPT files in SAS Procedures

Technical question about XPT files

Re: Technical question about XPT files