topic Re: Convert SAS V8 Transport File Format to SAS data set? in SAS Programming

Convert SAS V8 Transport File Format to SAS data set?

ybz12003 — Thu, 09 Jun 2016 15:45:26 GMT

Hi, all:

Does anyone know how to convert SAS V8 Transport File Format to SAS data set? Many thanks.

I created a code below:

libname source 'C:\My SAS Files\IIT';

libname xportout xport 'C:\My SAS Files\IIT\Data_CID_new version_hard drive.xpt';

data xportout.grades;

set source.grades;

run;

One Error message is shown that:

ERROR: File SOURCE.GRADES.DATA does not exist.

How is that come???

Re: Convert SAS V8 Transport File Format to SAS data set?

ballardw — Thu, 09 Jun 2016 19:16:12 GMT

Check your log to make sure the library was actually created.

Then check the spelling of your dataset name to ensure it is in the library.

I don't see where you are trying to convert a transport file though. The way you are using or xport library is for output not input.

typically I would expect to see Proc Cimport to read a transport file:

proc cimport library=mylib infile="path\file.xpt"; run;

Re: Convert SAS V8 Transport File Format to SAS data set?

FreelanceReinh — Thu, 09 Jun 2016 21:54:57 GMT

I agree with @ballardw that PROC CIMPORT is the right tool if the .xpt file was created using PROC CPORT. However, if it was created using the XPORT engine (in which case I think it would actually be a SAS V5 transport file), I would use:

proc copy in=xportout out=work; /* or choose another output library */
run;