Convert multiple xpt to sas files

[ari]

hi All,

I am using the code below to convert xpt files to sas files.

However, I see the following error message "ERROR: Libref XPTFILE is not assigned."

Any leadss to resolve this issue?

Thanks

%let path=E:\data\source;
filename xptfiles pipe "dir /b ""&path\%str(*).xpt"" " ;
filename code temp;
data files;
infile xptfiles truncover;
input filename $100. ;
file code;
put 'filename xptfile "&path\' filename +(-1) '" ;';
put 'proc copy inlib=xptfile outlib=ms; run;' ;
run;
libname ms 'E:\data\SAS datasets';
%inc code / source2 ;

[RW9]

Something like:

filename tmp pipe 'dir "c:/mypath/*.xpt" /b";

libname ms "c:/wanttokeeparea";

data _null_;
  infile tmp;
  input;
  call execute(cats('filename xptfile "c:/mypath/',_input_,'"));
  call execute('proc copy inlib=xptfile outlib=ms; run;');
  call execute('filename xptfile clear;');
run;
  

[Kurt_Bremser]

In preparation for proc copy, use a libname instead of a filename statement. Proc copy is for libraries and not file references.

[ari]

@Tom; Any comments?

[Tom]

@Kurt_Bremser has already given you the answer.

[LinusH]

Just a thought, given the filename extension, perhaps this file should be read by either PROC CIMPORT or the libname xport engine?