topic convert multiple xpt files inti sas datasets in SAS Programming

convert multiple xpt files inti sas datasets

paddyb — Wed, 28 Dec 2016 20:43:54 GMT

I have a folder in sas studio with multiple xpt files.How to convert it into sas datasets?I can do it choosing each file in to a dataset but how to make it dynamic?

Re: convert multiple xpt files inti sas datasets

SASKiwi — Wed, 28 Dec 2016 22:06:13 GMT

Start by getting the import for one file working properly first. Here is a link to the CIMPORT procedure to get you started:

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

A dynamic solution will most likely involve building a macro.

Re: convert multiple xpt files inti sas datasets

paddyb — Tue, 03 Jan 2017 06:28:46 GMT

libname xylib xport "/home/p0/AM2/data/agxpt/*.xpt ";
proc copy in=xylib out=work;
run;

I tried this to convert all xpt files frm agxpt folder but only 4 files i see converted into dataset.Folder have 7 files.Any idea why?

Re: convert multiple xpt files inti sas datasets

Bhavanaa — Sat, 01 Sep 2018 12:03:58 GMT

this didn't work when i am trying to extract multiple XPT files to SAS files.

Re: convert multiple xpt files inti sas datasets

Tom — Sat, 01 Sep 2018 15:31:12 GMT

The XPORT engine works on a single file.

Re: convert multiple xpt files inti sas datasets

Tom — Sat, 01 Sep 2018 16:45:23 GMT

Step one figure out if your XPT files are SAS V5 transport files, CPORT files or possibly the new V7 transport files that require using the SAS published macro to read. Then get the code to convert one file. So for a V5 transport file the code copy all of the dataset that are in the transport file to SAS datasets would look like this:

libname out "path";
libname in xport "filename";
proc copy inlib=in outlib=out;
run;

Where filename is the name of the XPT file and path is the directory where you want to write the files. To copy them as work datasets skip the first libname statement and just use WORK as the outlib in the proc copy step.

If the file was generated by PROC CPORT then you need to generate a PROC CIMPORT step instead.

Now get a list of the files. There are tons of posts on this site for how to do that.

Then either use the list to generate the LIBNAME,PROC COPY steps. For example if your list of filenames is in a data set named FILES and the variable with the filename is named FILENAME then that code could look like this:

filename code temp;
data _null_;
  set files ;
  file code ;
  put
  'libname in xport ' filename :$quote. ';'
/ 'proc copy inlib=in outlib=out; run; '
  ;
run;
%include code / source2 ;

Or you could create a little macro to do one file and generate the code to call the macro.