topic Most efficient way to program double sort? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/37807#M9663 <HTML><HEAD></HEAD><BODY><P> I'm not sure if I got the picture clear, but PROC SUMMARY using CLASS is usually very efficient.</P><P>/Linus</P></BODY></HTML> Wed, 25 Jan 2012 11:27:48 GMT LinusH 2012-01-25T11:27:48Z Most efficient way to program double sort? https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/37806#M9662 <HTML><HEAD></HEAD><BODY><P>Let's say I have the following data on firm size, profitability, and stock returns. The firms are sorted into terciles according to size and profitability like so:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">Obs</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">Size_Tercile</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">Profitability_Tercile</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Stock_Return</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>.12</TD></TR><TR><TD>2</TD><TD>1</TD><TD>1</TD><TD>.03</TD></TR><TR><TD>3</TD><TD>1</TD><TD>2</TD><TD>.21</TD></TR><TR><TD>4</TD><TD>1</TD><TD>2</TD><TD>.37</TD></TR><TR><TD>5</TD><TD>1</TD><TD>3</TD><TD>.14</TD></TR><TR><TD>6</TD><TD>1</TD><TD>3</TD><TD>.07</TD></TR><TR><TD>7</TD><TD>2</TD><TD>1</TD><TD>.19</TD></TR><TR><TD>8</TD><TD>2</TD><TD>2</TD><TD>.17</TD></TR><TR><TD>9</TD><TD>2</TD><TD>2</TD><TD>.06</TD></TR><TR><TD>10</TD><TD>2</TD><TD>2</TD><TD>.11</TD></TR><TR><TD>11</TD><TD>2</TD><TD>3</TD><TD>.42</TD></TR><TR><TD>12</TD><TD>2</TD><TD>3</TD><TD>-.13</TD></TR><TR><TD>13</TD><TD>3</TD><TD>1</TD><TD>.03</TD></TR><TR><TD>14</TD><TD>3</TD><TD>1</TD><TD>.05</TD></TR><TR><TD>15</TD><TD>3</TD><TD>2</TD><TD>.22</TD></TR><TR><TD>16</TD><TD>3</TD><TD>3</TD><TD>-.16</TD></TR><TR><TD>...</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>What's the most efficient way to program a double sort? I want to get average returns for the intersection of each size tercile with each profitability tercile:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><BR /></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Average Stock Returns sorted by firm size and profitability</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><BR /></SPAN></TH></TR><TR><TD><BR /></TD><TD><BR /></TD><TD>Profitability Terciles &lt;-&gt;</TD><TD><BR /></TD></TR><TR><TD>Size Terciles \/ \/</TD><TD>1</TD><TD>2</TD><TD>3</TD></TR><TR><TD>1</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR><TR><TD>2</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR><TR><TD>3</TD><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P></P><P>I'm looking for efficiency here because this process will be repeated for several different variables sorted not necessarily by just terciles. Thanks in advance.</P></BODY></HTML> Wed, 25 Jan 2012 11:15:22 GMT https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/37806#M9662 jaxonmills 2012-01-25T11:15:22Z Most efficient way to program double sort? https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/37807#M9663 <HTML><HEAD></HEAD><BODY><P> I'm not sure if I got the picture clear, but PROC SUMMARY using CLASS is usually very efficient.</P><P>/Linus</P></BODY></HTML> Wed, 25 Jan 2012 11:27:48 GMT https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/37807#M9663 LinusH 2012-01-25T11:27:48Z Re: Most efficient way to program double sort? https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/365584#M64770 <P>Hi Jaxonmills,</P><P>&nbsp;</P><P>Have you solve this problem? Please share with me, I am working on it now but I havenot found the solution for it.</P><P>&nbsp;</P><P>Thank you very much.</P> Fri, 09 Jun 2017 02:46:51 GMT https://communities.sas.com/t5/SAS-Procedures/Most-efficient-way-to-program-double-sort/m-p/365584#M64770 yotsuba88 2017-06-09T02:46:51Z