topic Re: how to open a xpt file? and convert xpt to xls? in SAS Programming

How to open a xpt file? And how to convert xpt to xls?

yangzhiyong — Fri, 04 Jun 2021 20:52:09 GMT

I am a new user ,I have a extend filename xpt file example demo_j.xpt file,I want to open it ,and convert to xls file?please help me ,tks

Re: how to open a xpt file? and convert xpt to xls?

ChrisNZ — Thu, 05 Nov 2020 07:14:47 GMT

How to read a XPT file, and how to create an excel file, has been discussed many times in this community.

Please search, try, and if you encounter problems, show your code and ask your question.

Re: how to open a xpt file? and convert xpt to xls?

yangzhiyong — Thu, 05 Nov 2020 13:00:58 GMT

LIBNAME XP XPORT "/folders/myfolders/sasuser.v94/DEMO_J.XPT";
PROC COPY IN=XP OUT=SASUSER;
RUN;

Re: how to open a xpt file? and convert xpt to xls?

yangzhiyong — Thu, 05 Nov 2020 13:03:28 GMT

ERROR: “SASUSER.DEMO_J.DATA” wirte is not accept

Re: how to open a xpt file? and convert xpt to xls?

Kurt_Bremser — Thu, 05 Nov 2020 13:11:14 GMT

SASUSER is per default opened read-only nowadays.

Use WORK or a library defined on the shared folder:

libname xp xport "/folders/myfolders/sasuser.v94/DEMO_J.XPT";
libname myfold "/folders/myfolders";

proc copy
  in=xp
  out=myfold
;
run;

Note that it is not necessary to shout at SAS to get it to work.

Re: how to open a xpt file? and convert xpt to xls?

Tom — Thu, 05 Nov 2020 13:46:01 GMT

The first thing you need to find out is whether the file with the XPT extension is a SAS XPORT file or a SAS CPORT file (or neither). You can check the first 80 bytes to tell, but it is probably just easier to try one method and if it doesn't work then try the other.

It is much easier to make an XLSX file than and XLS file. Plus they are more portable.

libname in xport 'demo_j.xpt';
libname out xlsx 'demo_j.xlsx';
proc copy inlib=in outlib=out;
run;

For a CPORT file you will need to use PROC CIMPORT instead.

proc cimport lib=out infile='demog_j.xpt';
run;

Re: how to open a xpt file? and convert xpt to xls?

yangzhiyong — Thu, 05 Nov 2020 13:49:28 GMT

Thank you very much!

Re: how to open a xpt file? and convert xpt to xls?

yangzhiyong — Thu, 05 Nov 2020 14:07:21 GMT

please help me to write code ,let the file to save a xls file,tks!

Re: how to open a xpt file? and convert xpt to xls?

wel51x — Tue, 17 Aug 2021 21:41:21 GMT

How do I do it if I have NO as in NONE access to SAS, just the .xpt file and excel?

I've been handed a file and told to make sense of it.

Doesn't seem to be a way.

Re: how to open a xpt file? and convert xpt to xls?

wel51x — Sat, 21 Aug 2021 18:24:08 GMT

Answering my own question; Here's quick and dirty python code:

import pandas as pd
FILE_PATH = "(directory containing file)"
FILE = "ABC" # filename itself (without suffix)

# Note: might need to substitute the column name of the index (in quotes) for "None" here

df = pd.read_sas(FILE_PATH + FILE + '.XPT', index=None)

df.to_csv(FILE_PATH + FILE + '.csv')