Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

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

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 82
Accepted Solution

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

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?


Accepted Solutions
Solution
‎02-03-2014 04:19 PM
Super User
Posts: 5,254

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

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. "

Data never sleeps

View solution in original post


All Replies
PROC Star
Posts: 7,356

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

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.

Solution
‎02-03-2014 04:19 PM
Super User
Posts: 5,254

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

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. "

Data never sleeps
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 277 views
  • 3 likes
  • 3 in conversation