https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324967#M9397 <P>I have two DI jobs have exact code and logic. But the order of data becomes different. I am trying to sort the data with emp_no, year, join_datetime. There are two records have same exact&nbsp;above three information. While sorting I&nbsp;get two different orders. DI 4.2 version for both the jobs.</P> Mon, 16 Jan 2017 06:09:08 GMT 89sankar 2017-01-16T06:09:08Z https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324967#M9397 <P>I have two DI jobs have exact code and logic. But the order of data becomes different. I am trying to sort the data with emp_no, year, join_datetime. There are two records have same exact&nbsp;above three information. While sorting I&nbsp;get two different orders. DI 4.2 version for both the jobs.</P> Mon, 16 Jan 2017 06:09:08 GMT https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324967#M9397 89sankar 2017-01-16T06:09:08Z https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324968#M9398 <P>This should not be happening, can you please post a screenshot of the output data?</P> Mon, 16 Jan 2017 06:15:18 GMT https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324968#M9398 mnjtrana 2017-01-16T06:15:18Z https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324971#M9399 SQL doesn't preserve original sort order. <BR />If you need original sort order you need to ad more ORDER BY columns. Mon, 16 Jan 2017 06:55:18 GMT https://communities.sas.com/t5/SAS-Data-Management/DI-studio-order-of-data-issue/m-p/324971#M9399 LinusH 2017-01-16T06:55:18Z