BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
sasgorilla
Pyrite | Level 9

I received a sas7bdat file that was created in SAS Enterprise Guide. When I run a proc contents on the file in SAS 9.4 I see a note in the log that says: 

 

NOTE: Data file WC000002.Final_data.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. 

Can someone explain what exactly this means, and the implications of this?

Would performance improve from receiving the file in another format (i.e. the original xlsx file) and importing myself? 

 

For the 10000000+ observations with over 50 variables, the processing time for the proc contents was 

real time (0.15 seconds)

cpu time (0.06 seconds)

 

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

This message occurs when the SAS dataset you are reading was created on a different SAS installation to yours, where there is a difference in the OS being used or different SAS encoding settings. You could just ignore the message for small datasets as the performance overhead is likely to be minimal.

 

That other message you are getting isn't related and you would need to provide more details of what is causing it.

View solution in original post

4 REPLIES 4
sasgorilla
Pyrite | Level 9

Also, I'm not sure this is related but I am seeing a pop up window everytime I run this code that says: 

 

WARNING: Extra arguments on window command were ignored.

 

Could this be related? I have had trouble finding what either of these things mean. 

SASKiwi
PROC Star

This message occurs when the SAS dataset you are reading was created on a different SAS installation to yours, where there is a difference in the OS being used or different SAS encoding settings. You could just ignore the message for small datasets as the performance overhead is likely to be minimal.

 

That other message you are getting isn't related and you would need to provide more details of what is causing it.

sasgorilla
Pyrite | Level 9

Okay, thanks! 

As for the pop up message, I will have to play around a little more and see if I can detect what is causing it. I'll reply back here if found. 

Ksharp
Super User
As SASKiwi pointed out , the reason why you get this message is due to the sas dataset(from sas/eg) encoding is different with your sas session.
For example:
your sas session 's encoding is EUC_CN, but sas dataset(from sas/eg) 's encoding is UTF-8 .
Check yours encoding :

%put &=sysencoding. ;



And Check sas dataset(from sas/eg) 's encoding:

proc contents data=sashelp.class;run;

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 779 views
  • 3 likes
  • 3 in conversation