03-04-2016 01:45 AM
How can I troubleshoot this error message?
NOTE: Data file EGFR.REPATED_MEASUREMENTS.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.
03-04-2016 01:56 AM
1) Could be the encoding of that sas table is different from your local sas session. You can change it like :
proc datasets library=work nodetails nolist; modify have/ correctencoding='utf8'; quit;
2)Could be OS that sas table be generated is different from your local PC OS. You can change it like :
data have(outrep='linux_32'); set sashelp.class; run;
03-04-2016 05:30 AM - edited 03-04-2016 05:32 AM
It might be encoding but it could also be due to the architectural difference between machines. If eg. your dataset was created on AIX or hp-ux and then the .sas7bdat file was moved over to Windows or Linux you will see this. It is due to the different byte order of the processor between the native OS and the current one. Have a look at https://nl.wikipedia.org/wiki/Endianness.
My first step would be to investigate the lifespan of the dataset from creation to where it is now. In any case you will be able to reconstruct the table to a native shape by copying it as KSharp suggested. Hope it's not a large one.
Hope this helps,
03-05-2016 11:43 AM