BookmarkSubscribeRSS Feed
deleted_user
Not applicable
My log is filled with iterations of this message identifying SAS Files in Libs I have allocated.

NOTE: Data file xxxxx.zzzzz 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.

1) What causes this mesasge to be displayed?
Most of the time the message references a file that I created from a SAS transport file, but not always. I thought SAS Transport files addressed the cross-environment

2) Is there any way to suppress it?
I changed my msglevel from 'N' to 'I', but the messages are still displayed (although they are in black instead of blue like the other messages).

I'm using Windows 9.2

This message dramatically increases the size of my log file (which I need to keep) and makes it very difficult to detect a real problem.


I'd appreciate any suggestions that woudl help me.
3 REPLIES 3
abdullala
Calcite | Level 5
it could be that your source data xxxx.zzzzz is created or transferred from a unix server.
one way to supress this particular message is to flank the part of code that generates the message with options nonotes; and options notes;
very likely it is the data step referring to this data set.
ChrisNZ
Tourmaline | Level 20
Have you read the CEDA pages?
Particularly:http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a002143983.htm

Also about data migration:
http://support.sas.com/rnd/migration/planning/files/crossplatform.html


Why CEDA Is Invoked for a SAS®9 File in a SAS®9 Session
Character encoding: CEDA is invoked when you share a file with users in another locale who have an incompatible encoding. For more information, see the topic about national language support or see Processing Data Using Cross-Environment Data Access (CEDA) in SAS Language Reference: Concepts.

Operating environment family: In a SAS®9 session, you can run the CONTENTS procedure on any SAS®9 file to determine the operating environment where it was created. To learn the operating environment of your current SAS®9 session, create a quick data set and run PROC CONTENTS on it. If the data representation of the file matches that of your current operating environment, then the file is native on that operating environment. If you're running under AIX, Solaris, or HP-UX, you'll notice all of those operating environments are listed in the log, because those operating environments comprise an operating environment family.




To know when CEDA is being used, set the SAS system option MSGLEVEL=I. That is:

options msglevel=i;
Here's an example of the message that displays in the log:

INFO: Data file MYFILES.GRADES.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.
Beginning with SAS 9.1.3 Service Pack 4, you get this behavior even if you do not specify MSGLEVEL=I.


Run proc contents, and use the OUTREP= option if needed.
data_null__
Jade | Level 19
[pre]
options generic;
[/pre]

update.

While this option does suppress the CEDA message it also effects how messages are displayed in LIBNAME and FILENAME statements which also effects the text returned by the PATHNAME function. This could be undesirable.

[pre]
options generic=0;
libname here '.';
libname here list;
%put NOTE: %sysfunc(pathname(here,L));


options generic=1;
%put NOTE: %sysfunc(pathname(here,L));
libname here list;

options generic=0;
%put NOTE: %sysfunc(pathname(here,L));
libname here list;
[/pre] GENERIC option effects more than CEDA message.


Message was edited by: data _null_;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1367 views
  • 0 likes
  • 4 in conversation