topic Re: to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through rate) in percentage format in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173011#M44567 <HTML><HEAD></HEAD><BODY><P>Use Proc Rank with groups=20 and then take the first group.</P></BODY></HTML> Thu, 19 Feb 2015 17:27:08 GMT Reeza 2015-02-19T17:27:08Z to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through rate) in percentage format https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173008#M44564 <HTML><HEAD></HEAD><BODY><P>to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through rate) in percentage format</P><P>witin campaign i have A,B C, D</P><P></P><P>campaign $ Email_addr $ CTR;</P><P></P><P><SPAN>A </SPAN><A class="jive-link-email-small" href="mailto:SFJHFK@KJFK.COM">SFJHFK@KJFK.COM</A><SPAN> 100%</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">A <SPAN style="font-size: 13.3333330154419px;"><A class="jive-link-email-small" href="mailto:SFGGFK@KJFK.COM">SFGGFK@KJFK.COM</A><SPAN> 100%</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">LIKE 1000 OBSER FOR EVERY CAMPAIGN.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">I WANT TO CALCULATE THE FIRST TOP 5 PERC OF CTR FOR EVERY CAMPAIGN<BR /></SPAN></P></BODY></HTML> Wed, 18 Feb 2015 10:24:09 GMT https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173008#M44564 ManoharNath 2015-02-18T10:24:09Z Re: to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through rate) in percentage format https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173009#M44565 <HTML><HEAD></HEAD><BODY><P>Please don't use capitals.&nbsp; By top 5%, what do you meant, the first 5% of records which appear in the dataset for each campaign, or something else.&nbsp; Please provide test data and required output.</P></BODY></HTML> Wed, 18 Feb 2015 10:30:44 GMT https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173009#M44565 RW9 2015-02-18T10:30:44Z Re: to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through rate) in percentage format https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173010#M44566 <HTML><HEAD></HEAD><BODY><P>I got the answer well sir, thanks for the reply <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Thu, 19 Feb 2015 11:13:12 GMT https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173010#M44566 ManoharNath 2015-02-19T11:13:12Z Re: to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through rate) in percentage format https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173011#M44567 <HTML><HEAD></HEAD><BODY><P>Use Proc Rank with groups=20 and then take the first group.</P></BODY></HTML> Thu, 19 Feb 2015 17:27:08 GMT https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/173011#M44567 Reeza 2015-02-19T17:27:08Z Re: to find out the top 5% in sas, i have three variables camp_name, email_addr, CTR(click through r https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/602613#M76441 <P>how would you get the top 5% that appear in the dataset? for various sized groups?</P> Thu, 07 Nov 2019 20:40:02 GMT https://communities.sas.com/t5/SAS-Procedures/to-find-out-the-top-5-in-sas-i-have-three-variables-camp-name/m-p/602613#M76441 rcogan 2019-11-07T20:40:02Z