Open .xpt

Cloudwilliam — Tue, 28 Dec 2021 19:13:16 GMT

Hello,

I downloaded a .xpt file for NHANES data. Could someone tell me how to open it with SAS?

Re: Open .xpt

Tom — Tue, 28 Dec 2021 23:09:15 GMT

Use the LIBNAME statement to make a libref using the XPORT engine pointing at the file you downloaded.

You can then reference the dataset by its name or use PROC COPY to copy it to a different libref, such as WORK.

1     %let path=C:\Downloads;
2     libname nhanes xport "&path\DEMO_D.xpt";
NOTE: Libref NHANES was successfully assigned as follows:
      Engine:        XPORT
      Physical Name: C:\Downloads\DEMO_D.xpt
3     proc copy inlib=nhanes out=work;
4     run;

NOTE: Input library NHANES is sequential.
NOTE: Copying NHANES.DEMO_D to WORK.DEMO_D (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used.
NOTE: There were 10348 observations read from the data set NHANES.DEMO_D.
NOTE: The data set WORK.DEMO_D has 10348 observations and 43 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           0.06 seconds
      cpu time            0.06 seconds

Re: Open .xpt

Ksharp — Wed, 29 Dec 2021 12:40:28 GMT

If your XPT is V8 version. Try this :

libname x v9 'c:\temp';
filename xpt 'c:\temp\temp.xpt';
%xpt2loc(libref=x,filespec=xpt)

SAS Help Center: SAS V8 Transport File Format

topic Re: Open .xpt in New SAS User

Open .xpt

Re: Open .xpt

Re: Open .xpt