topic sort in SAS Procedures

sort

rawindar — Tue, 20 Mar 2012 07:55:28 GMT

can we do sort operations with out using sort procedure.Is there any another concept.

Thanks in advance

regards

rawindarreddy

sort

Ksharp — Tue, 20 Mar 2012 09:02:04 GMT

How about SQL or Hash Table ?

proc sql;

create table want as

select * from sashelp.class

order by name;

quit;

Ksharp

sort

Haikuo — Tue, 20 Mar 2012 11:28:32 GMT

Following Ksharp's suggestion, an example of hash() solution on sorting:

data have;

input a;

cards;

;

data _null_;

if _n_=1 then do;

set have (obs=1);

dcl hash h(dataset: 'have',ordered:'a', multidata: 'yes');

h.definekey('a');

h.definedata('a');

h.definedone();

end;

h.output(dataset:'want');

run;

proc print;run;

sort

Doc_Duke — Tue, 20 Mar 2012 14:09:23 GMT

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

http://support.sas.com/resources/papers/proceedings10/140-2010.pdf

Doc Muhlbaier

Duke

sort

ballardw — Tue, 20 Mar 2012 20:55:08 GMT

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.

sort

rawindar — Wed, 21 Mar 2012 06:19:33 GMT

thanks Haikuo but i dont know Hash concept can you help me to understand what is hash

sort

rawindar — Wed, 21 Mar 2012 06:21:30 GMT

thanks ksharp i know about this iam looking for sas/base concept.Can you help me how could we do that using hash table and what is a hash concept

sort

manojinpec — Wed, 21 Mar 2012 08:41:46 GMT

Proc sql, Hash method, proc format are some of various ways

sort

Haikuo — Wed, 21 Mar 2012 11:16:24 GMT

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.

Regards,

Haikuo