BookmarkSubscribeRSS Feed
Kirsty
Calcite | Level 5

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;

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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;

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 3208 views
  • 0 likes
  • 2 in conversation