topic In DIS Table Loader , how to sort target in SAS Data Management

In DIS Table Loader , how to sort target

jplarios — Thu, 07 Jul 2011 14:36:31 GMT

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

DIS 3.1 SAS 9.13

In DIS Table Loader , how to sort target

Halaku — Fri, 08 Jul 2011 13:06:26 GMT

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

In DIS Table Loader , how to sort target

nar_sas — Wed, 13 Jul 2011 13:58:18 GMT

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.

In DIS Table Loader , how to sort target

jplarios — Sat, 23 Jul 2011 23:43:11 GMT

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