07-07-2011 10:36 AM
I have a proc sort prior to loading the target and when doing a proc contents on target it shows sorted as 'No'. I then go to the loaded and do sort order by the variable and I still get sort order 'no' on target based on contents of table.
I can't seem to make my target sorted. I thought I did but I noticed this when looking at contents.
DIS 3.1 SAS 9.13
07-13-2011 09:58 AM
The sort indicator is reset each time a table update occurs. So in this case, even though you have sorted a source SAS data set prior to loading to the target, the target table does not inherit the sort indicator from the source table. If the target table is actually in correct sort order as a result of loading a sorted source table, you can set the sort indicator to sorted=YES on the target using the SAS SORTEDBY data set option OR the datasets procedure MODIFY.
Hope this helps.