When I posted earlier about migrating Enterprise Miner models from SAS 9.1.3 to SAS 9.2 Alex Anglin from SAS quite rightly posted a comment mentioning that you should use Proc Migrate to move any dependent datasets if you are moving from a 32 bit server environment to a 64 bit server environment.
It got me thinking about how you can tell if the datasets you are using have been migrated correctly. I never got around to searching for an answer, but today I was running some code against one that obviously wasn’t as I got this int he SAS Log:
NOTE: Data file libname.dataset 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.
So I am assuming there are more automated ways of working out if a Dataset is in the correct format (feel free to post a comment with any suggestions) but I thought this was a pretty cool message.
Shane, try this program to check the encoding of data in a library:
%let Library = SASHELP;
proc sql;
title “Encoding of Data Sets in &Library”;
select libname, memname, datarep, datarepname, encoding
from sashelp.vtable where
libname=”&Library”
and memtype = ‘DATA’;
quit;
title;
Chris @ SAS