topic Filtering a column based on top 2% in SAS Programming https://communities.sas.com/t5/SAS-Programming/Filtering-a-column-based-on-top-2/m-p/208983#M306760 <HTML><HEAD></HEAD><BODY><P>I"m new to SAS so I apologize if I'm leaving anything out.</P><P></P><P>I have a column that has costs per member in it.&nbsp; Over 500k rows each unique members but some costs maybe the same.&nbsp; I need to filter out that table based on the Total_Cost column and I only want the top 2 percent of cost.&nbsp; I know how to do this in access, just enter 2% in the Top Values filter in properties,&nbsp; However I am not sure how to do this in SAS EG 5.1 which is what the company provides us with.&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Mon, 04 May 2015 15:36:07 GMT Xodiak 2015-05-04T15:36:07Z Filtering a column based on top 2% https://communities.sas.com/t5/SAS-Programming/Filtering-a-column-based-on-top-2/m-p/208983#M306760 <HTML><HEAD></HEAD><BODY><P>I"m new to SAS so I apologize if I'm leaving anything out.</P><P></P><P>I have a column that has costs per member in it.&nbsp; Over 500k rows each unique members but some costs maybe the same.&nbsp; I need to filter out that table based on the Total_Cost column and I only want the top 2 percent of cost.&nbsp; I know how to do this in access, just enter 2% in the Top Values filter in properties,&nbsp; However I am not sure how to do this in SAS EG 5.1 which is what the company provides us with.&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Mon, 04 May 2015 15:36:07 GMT https://communities.sas.com/t5/SAS-Programming/Filtering-a-column-based-on-top-2/m-p/208983#M306760 Xodiak 2015-05-04T15:36:07Z Re: Filtering a column based on top 2% https://communities.sas.com/t5/SAS-Programming/Filtering-a-column-based-on-top-2/m-p/208984#M306761 <HTML><HEAD></HEAD><BODY><P>If you want a SAS EG answer, it might be better to put this question to the SAS EG forum</P><P></P><P><A __default_attr="10" __jive_macro_name="community" class="jive_macro jive_macro_community" href="https://communities.sas.com/" modifiedtitle="true" title="SAS Enterprise Guide"></A></P><P></P><P>PG</P></BODY></HTML> Mon, 04 May 2015 16:40:57 GMT https://communities.sas.com/t5/SAS-Programming/Filtering-a-column-based-on-top-2/m-p/208984#M306761 PGStats 2015-05-04T16:40:57Z