BookmarkSubscribeRSS Feed
Kun
Calcite | Level 5 Kun
Calcite | Level 5

Hello, i am processing a dataset with more than 6M records in WPS. when i ran the following code, the error message popped up: ERROR: Too little memmory to complete ranking

please see the log below:

MPRINT(THETA):  proc rank  data=dsn1 out=ranked1;

MPRINT(THETA):  ranks rk_edf;

MPRINT(THETA):  var CCAEDF1;

MPRINT(THETA):  run;

NOTE: Line generated by the invoked macro "THETA"

15070   +  proc sql noprint;    select count(*) into :numall from &dsn;    select sum(&defvar) i

15070   +! nto :noOfdef from &dsn; quit;  proc rank  data=&dsn out=ranked1; ranks rk_edf; var &e

15070   +! dfvar; run;  data dsn_defaults; set ranked1;  if (&defvar eq 1);  run;  pro

ERROR: Too little memmory to complete ranking

NOTE: Procedure rank step took :

      real time : 30.628

      cpu time  : 6.177

can anyone help me?

Thanks.

2 REPLIES 2
Ksharp
Super User

Why did not you use GROUPS=  option in proc rank ?

scmebu
SAS Employee

I suggest you contact World Programming System technical support at World Programming.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1103 views
  • 0 likes
  • 3 in conversation