https://communities.sas.com/t5/SAS-Programming/Proc-sort-order-of-non-BY-variables/m-p/841812#M332853 <P>Hi if i have a table with 10 column, and i asked to sort it by col a col b col c.<BR />Lets say i have 3 cols where col a col b col c are the same, once the table us sorted by col a col b col c, how are the rest of the columns arranged? What does it based on?</P> Tue, 01 Nov 2022 13:24:16 GMT HeatherNewton 2022-11-01T13:24:16Z https://communities.sas.com/t5/SAS-Programming/Proc-sort-order-of-non-BY-variables/m-p/841812#M332853 <P>Hi if i have a table with 10 column, and i asked to sort it by col a col b col c.<BR />Lets say i have 3 cols where col a col b col c are the same, once the table us sorted by col a col b col c, how are the rest of the columns arranged? What does it based on?</P> Tue, 01 Nov 2022 13:24:16 GMT https://communities.sas.com/t5/SAS-Programming/Proc-sort-order-of-non-BY-variables/m-p/841812#M332853 HeatherNewton 2022-11-01T13:24:16Z https://communities.sas.com/t5/SAS-Programming/Proc-sort-order-of-non-BY-variables/m-p/841813#M332854 <P>The order of the observations within a group (as defined with BY) is&nbsp;<EM>usually</EM> that which existed before in the dataset, but this is not guaranteed, e.g. when data is read from a DBMS or SPD engines.</P> <P>If a certain order is required, you have to force it.</P> Tue, 01 Nov 2022 08:02:54 GMT https://communities.sas.com/t5/SAS-Programming/Proc-sort-order-of-non-BY-variables/m-p/841813#M332854 Kurt_Bremser 2022-11-01T08:02:54Z