topic Re: Convert multiple xpt to sas files in SAS Programming

Convert multiple xpt to sas files

ari — Thu, 23 Nov 2017 14:28:52 GMT

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 ;

Re: Convert multiple xpt to sas files

RW9 — Thu, 23 Nov 2017 14:38:16 GMT

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;

Re: Convert multiple xpt to sas files

Kurt_Bremser — Thu, 23 Nov 2017 15:07:47 GMT

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

Re: Convert multiple xpt to sas files

ari — Thu, 23 Nov 2017 17:33:50 GMT

@Tom; Any comments?

Re: Convert multiple xpt to sas files

Tom — Thu, 23 Nov 2017 18:07:31 GMT

@Kurt_Bremser has already given you the answer.

Re: Convert multiple xpt to sas files

LinusH — Fri, 24 Nov 2017 07:14:31 GMT

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