Hi @Patrick , i am running below code in test region.so here source.xx is nothing but my large table which has 800+ millions of records needs to be splitted and sorted. so when i run below code,i can see that large main dataset is being updated and changed. create sample source data */ data source.xx; do id=1 to 8000000000; do num=1 to 80000000000; bbbbb_other_var=catx('|',put(id,z3.),put(num,z3.)); output; end; end; stop; run; Also in code you provided we have like do key1=1 to 100; do key2=1 to 100; (Actually in my table how can i give these numeric values please.in my table key columns are having values as id=45678 num=11)but it is not in sequence like "1 to 100" please help me to understand whether how can i give values in my case please. also source (main dataset)is getting changed.
... View more