Help using Base SAS procedures

ERROR: Too little memmory to complete ranking

Reply
New Contributor Kun
New Contributor
Posts: 2

ERROR: Too little memmory to complete ranking

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.

Super User
Posts: 9,681

Re: ERROR: Too little memmory to complete ranking

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

SAS Employee
Posts: 17

Re: ERROR: Too little memmory to complete ranking

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

Ask a Question
Discussion stats
  • 2 replies
  • 216 views
  • 0 likes
  • 3 in conversation