topic Re: Using proc cport to create .xpt file in SAS Data Management

Using proc cport to create .xpt file

Kirsty — Thu, 04 Jan 2018 13:45:06 GMT

The following code creates a .xpt file but the file is not populated - it has no content other than a date and time stamp. There are no errors or warnings in the log - it states that there were 1147 observations as expected. Please can anyone explain why the data in _source are not carried across into the .xpt file?

proc cport data=_source file='Y:\F_Science\\Outputs\pc.xpt';

run;

Re: Using proc cport to create .xpt file

RW9 — Thu, 04 Jan 2018 14:00:40 GMT

You are missing a select:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473425.htm

Anyways, I wouldn't go that route with cport. Use a slightly different method:

filename tmp xport "y:/pc.xpt";

proc copy in=_source out=tmp;
run;

filename tmp clear;