Hi, I am currently in a project where we are migrating our SAS analytics from one Linux platform to another Linux platform. As part of the migration, i was testing some SAS code to check we get the same output results when running a same query on new server. To my surprise, what I found was that when I am trying to merge 2 datasets the resultant dataset is different from the one which was created in the old environment (althought the difference is of record being up and down). I have checked it using PROC COMPARE with EXACT method. To make by above question more clear: 2 datasets A and B were merged. Both A and B were created from raw data in the new environment and where checked using PROC COMPARE to ensure both the datasets are same in old and new environment. Datasets A and B were also checked using PROC COMPARE between the environment and were perfect match. Then A and B datasets were merged in new environment (C data created) and same thing was already done in old environment. When checked (C data between the env.) using PROC COMPARE it gave almost the entire data not matching. When i actually checked the records, i saw the record in both the datasets (C in old and C in new) were in different order (record 9 of C created in new env, is record 10 in C in old env. ). I have been searching through web, but didn;t get anything on this. Anybody has any idea what could be the issue. Thanks, Gaurav
... View more