topic open a XPT file in SAS studio in SAS Studio

open a XPT file in SAS studio

knighsson — Thu, 19 Mar 2020 17:51:31 GMT

New to sas studio. I checked previous questions, and tried different ways, it did not work.

In addition, I also use Mac, so this may be why it is so tricky.

My code is

libname NH "Macintosh HD/Users/llt/NHANES/DATA";

libname XP xport "Macintosh HD/Users/llt/NHANES/TEMP/demo_c.xpt";

proc copy in=XP out=NH; run;

Re: open a XPT file in SAS studio

ballardw — Thu, 19 Mar 2020 18:01:17 GMT

Please show the LOG that you get from running the code to help with diagnosing the issue. In this case I think you might want to be sure to include the Libname statement as well as the Proc Copy. Copy the text from the Log and paste into a code box opened on the forum using either the </> or "running man" icon to preserve text formatting. The message windows on the forum will reformat text and may move such things as characters that SAS shows in the log to indicate where an error occurred.

Re: open a XPT file in SAS studio

Kurt_Bremser — Thu, 19 Mar 2020 18:28:40 GMT

Mac OS X is a UNIX, and so all complete pathnames need to start with a forward slash, like

/Users/llt/NHANES/TEMP/demo_c.xpt

Also take care of exact spelling with regards to upper/lowercase.

If, in fact, you use SAS University Edition, you need to use the shared folder.

Re: open a XPT file in SAS studio

ballardw — Thu, 19 Mar 2020 19:01:12 GMT

Using the XPORT engine has these limitations: 

The XPORT engine supports only members of type DATA. It does not support members of type CATALOG orVIEW. 

The XPORT engine supports a feature set that is compatible with SAS 6. The XPORT engine cannot support SAS 9 features, such as long variable names. Warning or error messages report limitations that are encountered during the transport operation. For details about typical error messages and recovery actions, see File library.member.DATA has too long a member name for the XPORT engine . 

The XPORT engine with PROC COPY does not support the transport of any type of view or MDDB.