topic Re: ERROR: Too little memmory to complete ranking in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193297#M48525 <HTML><HEAD></HEAD><BODY><P>I suggest you contact World Programming System technical support at <A href="http://www.teamwpc.co.uk/contacting/support_question" title="http://www.teamwpc.co.uk/contacting/support_question">World Programming</A>.</P></BODY></HTML> Wed, 01 Jul 2015 13:46:24 GMT scmebu 2015-07-01T13:46:24Z ERROR: Too little memmory to complete ranking https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193295#M48523 <HTML><HEAD></HEAD><BODY><P>Hello, i am processing a dataset with more than 6M records in WPS. when i ran the following code, the error message popped up: <STRONG>ERROR: Too little memmory to complete ranking</STRONG></P><P></P><P>please see the log below:</P><P></P><P>MPRINT(THETA):&nbsp; proc rank&nbsp; data=dsn1 out=ranked1;</P><P>MPRINT(THETA):&nbsp; ranks rk_edf;</P><P>MPRINT(THETA):&nbsp; var CCAEDF1;</P><P>MPRINT(THETA):&nbsp; run;</P><P>NOTE: Line generated by the invoked macro "THETA"</P><P>15070&nbsp;&nbsp; +&nbsp; proc sql noprint;&nbsp;&nbsp;&nbsp; select count(*) into :numall from &amp;dsn;&nbsp;&nbsp;&nbsp; select sum(&amp;defvar) i</P><P>15070&nbsp;&nbsp; +! nto :noOfdef from &amp;dsn; quit;&nbsp; proc rank&nbsp; data=&amp;dsn out=ranked1; ranks rk_edf; var &amp;e</P><P>15070&nbsp;&nbsp; +! dfvar; run;&nbsp; data dsn_defaults; set ranked1;&nbsp; if (&amp;defvar eq 1);&nbsp; run;&nbsp; pro</P><P><STRONG>ERROR: Too little memmory to complete ranking</STRONG></P><P>NOTE: Procedure rank step took :</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; real time : 30.628</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cpu time&nbsp; : 6.177</P><P></P><P>can anyone help me? </P><P></P><P>Thanks.</P></BODY></HTML> Wed, 01 Jul 2015 07:11:49 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193295#M48523 Kun 2015-07-01T07:11:49Z Re: ERROR: Too little memmory to complete ranking https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193296#M48524 <HTML><HEAD></HEAD><BODY><P>Why did not you use GROUPS=&nbsp; option in proc rank ?</P></BODY></HTML> Wed, 01 Jul 2015 13:09:10 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193296#M48524 Ksharp 2015-07-01T13:09:10Z Re: ERROR: Too little memmory to complete ranking https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193297#M48525 <HTML><HEAD></HEAD><BODY><P>I suggest you contact World Programming System technical support at <A href="http://www.teamwpc.co.uk/contacting/support_question" title="http://www.teamwpc.co.uk/contacting/support_question">World Programming</A>.</P></BODY></HTML> Wed, 01 Jul 2015 13:46:24 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-Too-little-memmory-to-complete-ranking/m-p/193297#M48525 scmebu 2015-07-01T13:46:24Z