topic Re: How to find Version of the XPT file in SAS Programming

How to find Version of the XPT file

SASuserlot — Tue, 09 Jul 2024 18:39:41 GMT

I have a sas.xpt file , how to find the version of the xpt file. i tried proc contents but not much useful, is there any way we can find more information. Thanks for the help

Re: How to find Version of the XPT file

ballardw — Tue, 09 Jul 2024 20:00:59 GMT

The only version information I am aware of that might be in an XPT file would be the version of SAS that created the file. Is that what you are looking for?

Re: How to find Version of the XPT file

Ksharp — Wed, 10 Jul 2024 02:27:17 GMT

I remembered @Tom have already answered the question before.

Re: How to find Version of the XPT file

Tom — Wed, 10 Jul 2024 13:04:20 GMT

If you have a file with .xpt as the file extension you still need to know what type of file it is. Whether is was created by PROC CPORT or is was created by the XPORT libref engine. Or perhaps the new %LOC2XPT() SAS supplied autocall macro.

Here is a macro you can use that will read the first few bytes of the file and tell you want type of file it is.

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

/*----------------------------------------------------------------------------
Check file to see what type of transport file it is.

Returns
   CPORT for PROC CPORT/CIMPORT file
   XPORT for V5 export file
   XPORT_V9 for V8/9 export file
   SAS7BDAT for SAS dataset
   UNKNOWN for any other file

Examples:
  %put %xpttype('~/xport.xpt');
  %put %xpttype('~/subj.xpt');
  %put %xpttype('~/r_lrevw.xpt');
  %put %xpttype('~/test1.sas7bdat');

----------------------------------------------------------------------------*/

Re: How to find Version of the XPT file

SASuserlot — Wed, 10 Jul 2024 18:09:46 GMT

Thank you @Tom @Ksharp @ballardw