XPT file example in v8 format?

[romankuzmik]

I am implementing "Record Layout for a SAS Version 8 or 9 Data Set in SAS Transport Format" specification in Java/Groovy to be able to export XPT files from our proprietary application. We have "Record Layout for a SAS Version 5 or 6 Data Set in SAS Transport Format" implemented already and it generates valid XPT files I can open with SAS Universal Viewer. But the one generated according to v8 specification won't open in SAS Universal Viewer. btw, we use latest 1.4.2 version.

Can anyone provide me with actually working V8 XPT with some dummy data so I can compare with my files to understand where I am doing a mistake in my implementation.

Thanks! I do not have an access to actual SAS system and thus unable to generate XPT myself.

[Reeza]

That would likely violate the SAS licenses, since it's proprietary. I would recommend instead consider using the haven package from python or a similar package from R instead.

[romankuzmik]

The V8 transport specification is nonproprietary. 

https://documentation.sas.com/?docsetId=movefile&docsetTarget=n1h21k9w9rnhz3n1lrk8s9eib2bt.htm&docse...

[Reeza]

Or use a publicly available file so it doesn’t matter? 
https://www.cdc.gov/brfss/annual_data/annual_1990.htm

[Tom]

That file is just using normal V5 transport format.

[ChrisNZ]

@romankuzmik Did you get what you need?

[romankuzmik]

yes, got an access to SAS system and just generated V8.

bit surprised no one here could of generate this file for me.

[ChrisNZ]

Glad it all worked out in the end.

While it does seem that the specs are public, people are cautious about all things involving legal liability.

We'd have asked an admin for their opinion if you still needed help.

[Ksenia2]

Hello! I have the same issue, I need a dummy XPORT file in v8 format to test our Java open source parser that is going to support reading XPORT files. I wasn't able to find any publicly available .v8xpt, .xpt8, or .2xpt file on the Internet. I don't have access to any SAS system. I would be really grateful if somebody could share such file.

[Kurt_Bremser]

See attached file. It was created with PROC CPORT from SASHELP.CLASS and then zipped for uploading here.

[Ksenia2]

Thank you, but looks like it's still in V5, not V8 format 😞 According to the format documentation:

"The first header record consists of the following character string, in ASCII:
HEADER RECORD*******LIBV8 HEADER RECORD!!!!!!!000000000000000000000000000000"

And in the attached file it is 

"HEADER RECORD*******LIBRARY HEADER RECORD!!!!!!!000000000000000000000000000000"

[Tom]

A CPORT file is not an XPORT file.

To make a V5 XPORT file you can use the XPORT engine. But to make a V8 (or V9) XPORT file you have to use the SAS supplied macros (or write your own method).  Make sure when using the macro what type it generates, it might downgrade to V5 format automatically if your input dataset does not need any of the enhanced features.