SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

In DIS Table Loader , how to sort target

Reply
Regular Contributor
Posts: 163

In DIS Table Loader , how to sort target

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

Contributor
Posts: 38

In DIS Table Loader , how to sort target

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

SAS Employee
Posts: 36

In DIS Table Loader , how to sort target

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.

Regular Contributor
Posts: 163

In DIS Table Loader , how to sort target

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

Ask a Question
Discussion stats
  • 3 replies
  • 298 views
  • 2 likes
  • 3 in conversation