topic Re: Ranking huge dataset in Statistical Procedures

Ranking huge dataset

deleted_user — Fri, 28 Aug 2009 11:09:26 GMT

Hi,

How can we rank huge dataset like 9 millions in SAS?
If I use PROC RANK procedure, its throwing "Insuffient Memory" error message.

Can any body suggest any alternative procedure for ranking huge dataset.

Thanks in advance!!!

Thanks,
Pabitra

Re: Ranking huge dataset

datalligence — Fri, 28 Aug 2009 11:31:44 GMT

Hi Pabitra,

According to SAS, PROC RANK stores all values in memory of the variables for which it computes ranks. Check out the below paper for a workaround,

http://www.nesug.org/Proceedings/nesug04/pm/pm05.pdf

Hope it helps.

Datalligence
http://datalligence.blogspot.com/

Re: Ranking huge dataset

deleted_user — Tue, 01 Sep 2009 07:24:21 GMT

thanx Datalligence