In DIS Table Loader , how to sort target

[jplarios]

Hello,

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.

thanks

jp

DIS 3.1  SAS 9.13

[Halaku]

Do you have indexes on the columns you wish to sort? May be there is a dependency here. Update the metadata before retry.

[nar_sas]

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.

[jplarios]

Thanks Nar and Halaku. I ended up doing the sortedby option. after having my data sorted.