Hi all,
I'm trying to get deciles for a large file about 20-30 million recs. I'm running out of spool space on the sort part. Is there any way i could improve my sorts?
This is what i do. first, i get sums of sales per client. then, i assign deciles to the sales. finaly, i compute max, min, avg...