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 has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 971 views
  • 3 likes
  • 3 in conversation