topic Re: What does 'Sort Order' do on a column in a SAS table in SAS Data Science

What does 'Sort Order' do on a column in a SAS table

eagles_dare13 — Mon, 03 Feb 2014 19:53:39 GMT

In SAS DI Studio, if I create a new table with a few columns, I see there is the option of specifying 'Sort Order' on a column.

What does this do? if I specify 'Sort Order' ascending on a column and load data in the table in random un ordered fashion, will SAS automatically sort the data based on the column? It is not doing that, so I was wondering what is the use of a 'Sort Order' column?

Re: What does 'Sort Order' do on a column in a SAS table

art297 — Mon, 03 Feb 2014 21:09:35 GMT

I'm not familiar with DI Studio but, if the description at SAS(R) Data Integration Studio 4.21: User's Guide is what you are asking about, it is simply where you would specify the sort criteria to use when you do include a sort node.

Re: What does 'Sort Order' do on a column in a SAS table

LinusH — Mon, 03 Feb 2014 21:19:57 GMT

If you press help in the properties window for a table, the following is stated about Sort Order:

"The Sort Order field is used only to document the intended use of a given column. It does not implement a given usage. For example, selecting the ASCENDING value does not sort the values in that column when that column is used in a SAS Data Integration Studio job. "