DATA Step, Macro, Functions and more

NOTE: ... a format that is native to another host ...might reduce performance

Reply
Contributor
Posts: 53

NOTE: ... a format that is native to another host ...might reduce performance

Hi,

I am using data sets downloaded from Wharton Research Data Service (WRDS) on my PC SAS 9.2, 32 bit. Every time I run a data step using a data set downloaded from WRDS, I get the following message appearing in the log, which is a little annoying:

NOTE: Data file XXX.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance.

I think I understand what I need to about the origin of the message, but my questions are:

1. How do I really know if it is reducing performance? I can't tell that it is apart from it taking a fraction of second longer to open these data sets in the VIEW TABLE. As for the SAS code that I am running, they seem to do fine. Is there something else I need to worry about with these messages?

2. What can I do to make the data sets that I download compatible with my version of PC SAS? Do I need to resave the downloaded data sets in my version of SAS? How do I do that, if I need to at all.

Thanks

Ian.

Trusted Advisor
Posts: 2,113

Re: NOTE: ... a format that is native to another host ...might reduce performance

see 15379 - Cross-Environment Data Access (CEDA) utilization message

(I just searched SAS support for <cross environment data access>).

Contributor
Posts: 53

Re: NOTE: ... a format that is native to another host ...might reduce performance

thanks

Super User
Posts: 9,676

Re: NOTE: ... a format that is native to another host ...might reduce performance

OR try to use proc migrate to migrate the dataset into your local machine.

Ask a Question
Discussion stats
  • 3 replies
  • 1557 views
  • 8 likes
  • 3 in conversation