topic Re: How do I import an xpt file using manage data import GUI in SAS VIYA in SAS Programming

How do I import an xpt file using manage data import GUI in SAS VIYA

zenenceladus — Fri, 22 Apr 2022 17:49:36 GMT

Do to our installation we are forced to import files from our desktop using the import GUI in SAS VIYA> When I try to import am xpt file I get an error message that the file type is unsupported. I have no problem importing the same xpt files into JMP.

Re: How do I import an xpt file using manage data import GUI in SAS VIYA

ChrisHemedinger — Fri, 22 Apr 2022 19:23:07 GMT

I don't think you want to use the Import function. XPT files are read using a SAS library engine (XPORT), so the approach would be to upload the XPT files you need and then use code to assign a libname to each file.

Example code:

libname data xport "&_userhome/XPT/class.xpt"; proc contents data=data.class; quit;

Re: How do I import an xpt file using manage data import GUI in SAS VIYA

Tom — Sat, 23 Apr 2022 02:05:20 GMT

If the file is not accessible on the machine where SAS (whatever flavor) is running then you need to get the file there first.

So if your site has totally disabled your ability to upload a file then they need to provide some other method for you put the file where SAS can access it.

The IMPORT wizard is not the tool for working with XPT files. It might be in JMP since that is foreign file structure to JMP.

Re: How do I import an xpt file using manage data import GUI in SAS VIYA

emilykennewell — Mon, 05 Feb 2024 15:11:58 GMT

proc contents data=data.class; quit;: This code block is using the proc contents procedure to display information about the contents of the specified dataset. In this case, it's the "class" dataset within the "data" library. This helps you understand the structure of the dataset, such as variable names, types, and formats.

If you have multiple XPT files, you can repeat the libname statement for each file and then use the appropriate dataset names in subsequent SAS procedures.

Ensure that the path to your XPT file is correct, and replace "&_userhome/XPT/class.xpt" with the actual path to your XPT file.

Re: How do I import an xpt file using manage data import GUI in SAS VIYA

Tom — Mon, 05 Feb 2024 15:18:51 GMT

The extension XPT has no fixed meaning. So it MIGHT be a file in the SAS V5 Transport format that can be read with the XPORT library engine. But it might be a file created with PROC CPORT that would require using PROC CIMPORT to read. Or it might be a SAS V7/8/9 Transport file create by the %LOC2XPT() macro in which case you would need to use the %XPT2LOC() macro to read it.

I don't use JMP, but perhaps the information that it can be imported by JMP would tell someone that is familiar with JMP what type of file it is.