topic Re: Convert XPT to SAS Dataset in SAS Programming

Convert XPT to SAS Dataset

GS2 — Mon, 10 Jan 2022 16:44:57 GMT

Using SAS 9.4

I have received 17 SAS transport files and cannot seem to find code for how to convert these files to a SAS dataset. I have tried the code below with no success to convert one xpt, would anyone know what I am doing incorrectly? Thank you

libname sasfile “path\IHMR”;

libname xptfile xport “path\IHMR\ae.xpt” access=readonly;

proc copy inlib=xptfile outlib=sasfile;

run;

Re: Convert XPT to SAS Dataset

Reeza — Mon, 10 Jan 2022 16:47:46 GMT

Code looks correct. What errors do you get?

@GS2 wrote:

Using SAS 9.4

I have received 17 SAS transport files and cannot seem to find code for how to convert these files to a SAS dataset. I have tried the code below with no success to convert one xpt, would anyone know what I am doing incorrectly? Thank you

libname sasfile “path\IHMR”;

libname xptfile xport “path\IHMR\ae.xpt” access=readonly;

proc copy inlib=xptfile outlib=sasfile;

run;

Re: Convert XPT to SAS Dataset

ballardw — Mon, 10 Jan 2022 16:52:00 GMT

Show us the log for all the code you have shown.

Re: Convert XPT to SAS Dataset

GS2 — Mon, 10 Jan 2022 16:55:15 GMT

NOTE: SAS initialization used:
      real time           40.26 seconds
      cpu time            3.56 seconds

1    libname sasfile 'path\IHMR';
NOTE: Libref SASFILE was successfully assigned as follows:
      Engine:        V9
      Physical Name: path\IHMR
2    libname xptfile xport 'path\IHMR\ae.xpt' access=readonly;
NOTE: Libref XPTFILE was successfully assigned as follows:
      Engine:        XPORT
      Physical Name: path\IHMR\ae.xpt
3    proc copy inlib=xptfile outlib=sasfile;
NOTE: Writing HTML Body file: sashtml.htm
4    run;

NOTE: Input library XPTFILE is sequential.
ERROR: File XPTFILE.ALL. is not a SAS data set.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE COPY used (Total process time):
      real time           8.18 seconds
      cpu time            0.57 seconds

NOTE: The SAS System stopped processing this step because of errors.

Re: Convert XPT to SAS Dataset

Reeza — Mon, 10 Jan 2022 16:56:32 GMT

Is the AE file a public file? If so, can you share the original source? Seems like a corrupt download possibly.

Re: Convert XPT to SAS Dataset

GS2 — Mon, 10 Jan 2022 16:58:31 GMT

My log with the errors is posted above

Re: Convert XPT to SAS Dataset

GS2 — Mon, 10 Jan 2022 17:03:13 GMT

Unfortunately it is not a public file. However, It was a file I was given. So, potentially the person who sent the file did not convert the dataset to an xpt file correctly?

Re: Convert XPT to SAS Dataset

Tom — Mon, 10 Jan 2022 17:27:16 GMT

Are you sure the file is an XPORT format file?

Look at the top of the file to see:

data _null_;
  infile 'path\IHMR\ae.xpt' lrecl=80 recfm=f obs=5;
  input;
  list;
run;

Re: Convert XPT to SAS Dataset

GS2 — Mon, 10 Jan 2022 17:39:00 GMT

5    data _null_;
6      infile 'path\IHMR\Data_112921\ae.xpt'
6  ! lrecl=80 recfm=f obs=5;
7      input;
8      list;
9    run;

NOTE: The infile 'path\IHMR\Data_112921\ae.xpt' is:
      Filename=path\IHMR \Data_112921\ae.xpt,
      RECFM=F,LRECL=80,File Size (bytes)=240,
      Last Modified=07Jan2022:14:22:53,
      Create Time=05Jan2022:09:18:36

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9--
1         HEADER RECORD*******LIBV8   HEADER RECORD!!!!!!!000000000000000000000000000000

2   CHAR  SAS     SAS     SASLIB  9.1     WIN.....                        07JAN22:14:22:54
    ZONE  54522222545222225454442232322222544000002222222222222222222222223344433333333333
    NUMR  3130000031300000313C92009E10000079E0000000000000000000000000000007A1E22A14A22A54
3         07JAN22:14:22:54
NOTE: 3 records were read from the infile 'path\IHMR\Data_112921\ae.xpt'.
NOTE: DATA statement used (Total process time):
      real time           0.25 seconds
      cpu time            0.10 seconds

Above is the log after running the code

Re: Convert XPT to SAS Dataset

Tom — Mon, 10 Jan 2022 17:50:05 GMT

So you don't have an XPORT file. That format only supports SAS V5 transport files.

Instead you have the modified format that requires you use to SAS supplied macros to convert. For some reason rather than generating a new engine that could work with longer names and longer variables they created SAS macros.

Use %XPT2LOC to convert your file into SAS dataset(s).

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/movefile/p1tp8gighlgeifn173i6kzw2w3bu.htm

Re: Convert XPT to SAS Dataset

Tom — Mon, 10 Jan 2022 18:01:35 GMT

Your file appears truncated.

After the first three records you should see HEADER records to indicate the start of an actual dataset.

Let's make an example transport file using the macros and see what the beginning of it looks like:

filename xxx temp;
%loc2xpt(libref=sashelp,memlist=class,filespec=xxx,format=V9);
data _null_;
  infile xxx recfm=f lrecl=80 obs=7;
  input;
  list;
run;

Results:

RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
1         HEADER RECORD*******LIBV8   HEADER RECORD!!!!!!!000000000000000000000000000000

2   CHAR  SAS     SAS     SASLIB  9.1     WIN.....                        10JAN22:12:58:52
    ZONE  54522222545222225454442232322222544000002222222222222222222222223344433333333333
    NUMR  3130000031300000313C92009E10000079E0000000000000000000000000000010A1E22A12A58A52
3         10JAN22:12:58:52
4         HEADER RECORD*******MEMBV8  HEADER RECORD!!!!!!!000000000000000001600000000140
5         HEADER RECORD*******DSCPTV8 HEADER RECORD!!!!!!!000000000000000000000000000000

6   CHAR  SAS     CLASS                           SASDATA 9.1     WIN.....10JAN22:12:58:52
    ZONE  54522222444552222222222222222222222222225454454232322222544000003344433333333333
    NUMR  313000003C133000000000000000000000000000313414109E10000079E0000010A1E22A12A58A52
7         10JAN22:12:58:52                Student Data

Re: Convert XPT to SAS Dataset

Reeza — Mon, 10 Jan 2022 18:17:28 GMT

1. Try reading in another XPT file and see if that works for you. If not, you have an issue with SAS. The link to an example NHANES xpt file is there for you.

2. If it works, try redownloading the file you were sent by your colleague and uncompress it (if zipped). If that fails, then you have a bad file and I'd ask whomeever sent it to you to recreate the file and resend it.

Re: Convert XPT to SAS Dataset

GS2 — Mon, 10 Jan 2022 18:36:18 GMT

Demo_J runs like it is supposed to with my original code. I tried a new file and downloaded the same file again and both do not work. So, likely this is an error on the part of the sender? Thank you

Re: Convert XPT to SAS Dataset

Tom — Mon, 10 Jan 2022 19:08:04 GMT

Your original code will not work on V8/V9 versions of transport files, which is what your truncated ae.xpt file was.

You need to use the %XPT2LOC() macro to convert instead.

libname sasfile "path\IHMR";
%xpt2loc(libref=sasfile,filespec="path\IHMR\ae.xpt");