Q. What is the XPORT transport format, generally ?
A. This is a popular extension that works fine with the SAS System and is supported by JMP, the SAS System Viewer,
and soon will be supported by the UODBC driver. Generally ".xpt" is the XPORT filename extension.
It is a text file, with record length = 80 columns. It looks and feels so much like a text file
that it is a good idea to avoid using ".txt" as a file name extension so that the operating system won't
treat it as a text file.
For details: http://www.sas.com/industry/government/fda/faq.html
Q. How does XPORT transport file read into SAS (9.1) ?
A. This example uses the DATA step to restore a data set from a transport file.
libname xportin xport '';
libname target '';
data target.'transport-file name here' ; /* If you want you can have a your own file name here */
set xportin.'transport-file name here' ;
run;
Example :
Suppose file path of my XPORT transport file name 'xpt_infile.xpt' is 'C:\Wilson'
and target SAS dataset should be in the 'C:\Wilson\data', then SAS code will be
libname xportin xport 'C:\Wilson\xpt_infile.xpt';
libname target 'C:\Wilson\data';
data target. xpt_infile ;
set xportin. xpt_outfile;
run;
