03-20-2012 07:28 AM
Following Ksharp's suggestion, an example of hash() solution on sorting:
if _n_=1 then do;
set have (obs=1);
dcl hash h(dataset: 'have',ordered:'a', multidata: 'yes');
03-21-2012 07:16 AM
Do a googling on 'SAS Hash', you will find tons of sugi papers on this topic, that is at least how I started. Plus SAS online documentation and practice, you will have a taste of it before you know it.
03-20-2012 10:09 AM
Another possibility is to have the PROC SORT procedure use another sort tool. A lot of mainframe shops do that with SyncSort.
For some actities, you can use PROC FORMAT to accomplish the goal of a SORT.
Note that all of these procedures may give you different results when there are ties on the sort keys.
This paper may be helpful
03-20-2012 04:55 PM
If you don't need all of the data , depending on your needs several procs such as FREQ, MEANS or SUMMARY using class variables, and TABULATE will produce sorted output and output datasets.
Need further help from the community? Please ask a new question.