topic Re: How to find largest and second largest values? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812134#M320412 thanks a lot Mon, 09 May 2022 11:43:00 GMT srikanthyadav44 2022-05-09T11:43:00Z How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812068#M320373 <P>dear all,</P><P>i have the data set in the following format</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type&nbsp;</TD><TD>percent_shares</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>10.76</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.37</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.01</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>9.26</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.61</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.13</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.04</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>6.81</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.25</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.58</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.18</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.18</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.05</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.36</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>1.39</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.64</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.33</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>0.17</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Non-Promoters</TD><TD>18.67</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Non-Promoters</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>10.8</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>18.94</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>6.81</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.06</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.19</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.58</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.05</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>1.39</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Promoters</TD><TD>0.33</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i have to compute largest and second largest values of percent_shares for each 'company' for 'year' for each 'type' .</P><P>my output should be in the following format</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type&nbsp;</TD><TD>percent_shares</TD><TD>first_largest</TD><TD>second_largest</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest me a SAS code in this regard&nbsp;</P><P>thanking you in advance&nbsp;</P> Mon, 09 May 2022 04:48:22 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812068#M320373 srikanthyadav44 2022-05-09T04:48:22Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812069#M320374 <P>how about this code?</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; length company_name $15 year 8 type $16 percent_shares 8; input company_name $ 1-15 year type $ 22-37 percent_shares; datalines; 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.77 20 Microns Ltd. 2010 Locked-In Shares 2.5 20 Microns Ltd. 2010 Locked-In Shares 0.57 20 Microns Ltd. 2010 Locked-In Shares 0.35 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 1.85 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0.5 20 Microns Ltd. 2010 Locked-In Shares 10.76 20 Microns Ltd. 2010 Locked-In Shares 0.37 20 Microns Ltd. 2010 Locked-In Shares 0.01 20 Microns Ltd. 2010 Locked-In Shares 9.26 20 Microns Ltd. 2010 Locked-In Shares 0.61 20 Microns Ltd. 2010 Locked-In Shares 0.13 20 Microns Ltd. 2010 Locked-In Shares 0.14 20 Microns Ltd. 2010 Locked-In Shares 0.08 20 Microns Ltd. 2010 Locked-In Shares 0.12 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.65 20 Microns Ltd. 2010 Locked-In Shares 0.21 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 0.04 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0 20 Microns Ltd. 2010 Locked-In Shares 6.81 20 Microns Ltd. 2010 Locked-In Shares 1.25 20 Microns Ltd. 2010 Locked-In Shares 0.58 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 1.05 20 Microns Ltd. 2010 Locked-In Shares 0.36 20 Microns Ltd. 2010 Locked-In Shares 1.39 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.64 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.33 20 Microns Ltd. 2010 Locked-In Shares 0.17 20 Microns Ltd. 2010 Non-Promoters 18.67 20 Microns Ltd. 2010 Non-Promoters 1.65 20 Microns Ltd. 2010 Promoters 0.77 20 Microns Ltd. 2010 Promoters 2.5 20 Microns Ltd. 2010 Promoters 0.57 20 Microns Ltd. 2010 Promoters 0.35 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 1.85 20 Microns Ltd. 2010 Promoters 10.8 20 Microns Ltd. 2010 Promoters 18.94 20 Microns Ltd. 2010 Promoters 0.14 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.08 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.21 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 6.81 20 Microns Ltd. 2010 Promoters 0.06 20 Microns Ltd. 2010 Promoters 1.19 20 Microns Ltd. 2010 Promoters 0.58 20 Microns Ltd. 2010 Promoters 1.05 20 Microns Ltd. 2010 Promoters 1.39 20 Microns Ltd. 2010 Promoters 0.33 ; run; proc sort data=have out=sorted; by company_name year type descending percent_shares; run; data want; set sorted; by company_name year type descending percent_shares; retain first_largest second_largest flg; if first.type then do; flg=1; first_largest =percent_shares; second_largest=.; end; else flg+1; if flg=2 or (first.type and last.type) then do; second_largest=percent_shares; output; end; drop percent_shares flg; run;</CODE></PRE> <P>&nbsp;It would be helpful if you could present the sample data in a usable form in the DATA step if possible.</P> <P>&nbsp;</P> Mon, 09 May 2022 05:07:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812069#M320374 japelin 2022-05-09T05:07:18Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812070#M320375 <P>What should&nbsp;<SPAN>percent_shares contain in the want data set?</SPAN></P> Mon, 09 May 2022 05:08:26 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812070#M320375 PeterClemmensen 2022-05-09T05:08:26Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812074#M320379 <P>Classic use of the IDGROUP Option in Proc Summary</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc summary data=have nway; class company_name year type; var percent_shares; output out=want(drop=_:) idgroup (max(percent_shares) out[2] (percent_shares) = largest); run;</CODE></PRE> Mon, 09 May 2022 05:22:14 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812074#M320379 PeterClemmensen 2022-05-09T05:22:14Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812077#M320382 <P>Look like the same problem you have discussed in <A href="https://communities.sas.com/t5/SAS-Programming/how-to-find-the-sum-of-first-three-largest-shareholdings/m-p/811372" target="_blank">https://communities.sas.com/t5/SAS-Programming/how-to-find-the-sum-of-first-three-largest-shareholdings/m-p/811372</A></P> Mon, 09 May 2022 05:42:44 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812077#M320382 andreas_lds 2022-05-09T05:42:44Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812090#M320390 What if there are ties for max value ,what you want to display ? Mon, 09 May 2022 08:51:24 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812090#M320390 Ksharp 2022-05-09T08:51:24Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812094#M320393 <P>Ha. I just test it . If you have two same MAX value and PROC SUMMARY would keep them all.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ksharp_0-1652086810210.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/71223i08732319024979AB/image-size/medium?v=v2&amp;px=400" role="button" title="Ksharp_0-1652086810210.png" alt="Ksharp_0-1652086810210.png" /></span></P> <P>&nbsp;</P> Mon, 09 May 2022 09:00:16 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812094#M320393 Ksharp 2022-05-09T09:00:16Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812096#M320394 <P>If you want display two unique max value .</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; length company_name $15 year 8 type $16 percent_shares 8; input company_name $ 1-15 year type $ 22-37 percent_shares; datalines; 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.77 20 Microns Ltd. 2010 Locked-In Shares 2.5 20 Microns Ltd. 2010 Locked-In Shares 0.57 20 Microns Ltd. 2010 Locked-In Shares 0.35 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 1.85 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 10.76 /*same value*/ 20 Microns Ltd. 2010 Locked-In Shares 10.76 /*same value*/ 20 Microns Ltd. 2010 Locked-In Shares 0.37 20 Microns Ltd. 2010 Locked-In Shares 0.01 20 Microns Ltd. 2010 Locked-In Shares 9.26 20 Microns Ltd. 2010 Locked-In Shares 0.61 20 Microns Ltd. 2010 Locked-In Shares 0.13 20 Microns Ltd. 2010 Locked-In Shares 0.14 20 Microns Ltd. 2010 Locked-In Shares 0.08 20 Microns Ltd. 2010 Locked-In Shares 0.12 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.65 20 Microns Ltd. 2010 Locked-In Shares 0.21 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 0.04 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0 20 Microns Ltd. 2010 Locked-In Shares 6.81 20 Microns Ltd. 2010 Locked-In Shares 1.25 20 Microns Ltd. 2010 Locked-In Shares 0.58 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 1.05 20 Microns Ltd. 2010 Locked-In Shares 0.36 20 Microns Ltd. 2010 Locked-In Shares 1.39 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.64 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.33 20 Microns Ltd. 2010 Locked-In Shares 0.17 20 Microns Ltd. 2010 Non-Promoters 18.67 20 Microns Ltd. 2010 Non-Promoters 1.65 20 Microns Ltd. 2010 Promoters 0.77 20 Microns Ltd. 2010 Promoters 2.5 20 Microns Ltd. 2010 Promoters 0.57 20 Microns Ltd. 2010 Promoters 0.35 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 1.85 20 Microns Ltd. 2010 Promoters 10.8 20 Microns Ltd. 2010 Promoters 18.94 20 Microns Ltd. 2010 Promoters 0.14 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.08 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.21 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 6.81 20 Microns Ltd. 2010 Promoters 0.06 20 Microns Ltd. 2010 Promoters 1.19 20 Microns Ltd. 2010 Promoters 0.58 20 Microns Ltd. 2010 Promoters 1.05 20 Microns Ltd. 2010 Promoters 1.39 20 Microns Ltd. 2010 Promoters 0.33 ; run; proc sort data=have ;by company_name year type ;run; ods select none; ods output ExtremeValues=ExtremeValues; proc univariate data=have nextrval=2; by company_name year type; var percent_shares; run; ods select all; proc sort data=ExtremeValues;by company_name year type descending High;run; proc transpose data=ExtremeValues out=want(drop=_:) prefix=largest_; by company_name year type; var High; run;</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ksharp_0-1652087460293.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/71224iF299AF24A89A9FFC/image-size/medium?v=v2&amp;px=400" role="button" title="Ksharp_0-1652087460293.png" alt="Ksharp_0-1652087460293.png" /></span></P> <P>&nbsp;</P> Mon, 09 May 2022 09:11:08 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812096#M320394 Ksharp 2022-05-09T09:11:08Z Re: How to find largest and second largest values? https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812134#M320412 thanks a lot Mon, 09 May 2022 11:43:00 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-largest-and-second-largest-values/m-p/812134#M320412 srikanthyadav44 2022-05-09T11:43:00Z