BookmarkSubscribeRSS Feed
jitendrakoli
Fluorite | Level 6

Dear All,

We have newly installed SAS 9.4 Office Analytics on server and access through client machine with enterprise guide 8.2. We are new to use this combination.

We can generate xpt file from client machine but same generated xpt file can't be open/read from client machine, please requesting all of you to provide solution.

 

Thanks..

2 REPLIES 2
SASKiwi
PROC Star

How are you generating the XPT files and how are you trying to read them. Please post any SAS logs of these processes.

 

What is the reason for creating XPT files when SAS clients can read "normal" SAS datasets - SAS7BDAT files.

Tom
Super User Tom
Super User

What do you mean by an "xpt" file?  SAS can make two types of transport files.  You can use the XPORT engine to make a V5 transport file (or use the new %xpt2loc and %loc2xpt macros to make V7/V8/V9 "xport" files).

Or you can use PROC CPORT to make a transportable file that can include catalogs and other SAS files in addition to datasets.

 

The XPORT files are version independent (unless you are really running version 6 or earlier and trying to read a dataset with long variable names or long character variables).

 

But the CPROT files are only forward compatible. You can read an file made with an older version of SAS than waht you are running, but you cannot read one made with a version of SAS that is newer than the version you are running.

 

So if you are making CPORT files with a newer version of SAS and then trying to read them with a older version of SAS you will have trouble.

 

But why are you doing anything with either type of export format if you are using a SAS plug in to Office?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 729 views
  • 0 likes
  • 3 in conversation