topic Re: Invalid SAS transport file, problem on second record in SAS Procedures

Invalid SAS transport file, problem on second record

Elisa — Fri, 16 May 2014 14:06:11 GMT

I am generating single dataset transport files using the PROC CPORT method. I have no error/warning messages in the conversion to transport files, and have no issues re-importing the datasets using PROC CIMPORT. However, if I try to open the .xpt file using Universal Viewer then I get an error ("The file xxxxx could not be loaded, Invalid SAS transport file, problem on second record").

Can anyone please shed light on the cause of such an error. I've even tried a really simple test dataset (one variable, one entry), and still get the error.

Here's the code I'm using to generate the transport files:

%macro export (data=);

filename &data "path......\&data..xpt";

proc cport data=ITP.&data file=&data;

run;

%mend export;

%export (data=ADR)

%export (data=COMPL)

%export (data=CONMEDS)

....................................

Thanks in advance!

Elisa

Re: Invalid SAS transport file, problem on second record

AnalytX — Wed, 07 Jan 2015 10:52:21 GMT

Hi everybody,

I have exacly the same problem. If anyone has an answer, it would be very helpful.

Best,

Re: Invalid SAS transport file, problem on second record

Elisa — Thu, 08 Jan 2015 01:06:28 GMT

I did end up finding the solution. Datasets created by PROC CPORT have to be read into SAS by using PROC CIMPORT. You can name the *.xpt, but it is not actually a v5 xpt format file. SAS viewer can't open datasets created by PROC CPORT. To create v5 xpt files you need to use XPORT engine. An Example:

%macro v5export (data=);

libname &DATA xport "C:\&DATA..xpt";

proc copy in=ITP out=&DATA memtype=data;

select &DATA;

run;

%mend v5export;

%v5export (data=ADR)

%v5export (data=COMPL)

%v5export (data=CONMEDS)

Re: Invalid SAS transport file, problem on second record

AnalytX — Thu, 08 Jan 2015 08:49:21 GMT

Hi Elisa,

Thanks a lot for your answer which is of a great help!

Best regards,