topic Re: Filtering a column based on top 2% in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-a-column-based-on-top-2/m-p/209042#M15645 <HTML><HEAD></HEAD><BODY><P>First use the Rank Task - this will create a new columns for you with ranks.</P><P>Then use a Filter and Sort Task (or Query Builder) and filter on the new created column.</P></BODY></HTML> Mon, 04 May 2015 21:58:46 GMT gergely_batho 2015-05-04T21:58:46Z Filtering a column based on top 2% https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-a-column-based-on-top-2/m-p/209041#M15644 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">I"m new to SAS so I apologize if I'm leaving anything out.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">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. </P></BODY></HTML> Mon, 04 May 2015 17:26:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-a-column-based-on-top-2/m-p/209041#M15644 Xodiak 2015-05-04T17:26:48Z Re: Filtering a column based on top 2% https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-a-column-based-on-top-2/m-p/209042#M15645 <HTML><HEAD></HEAD><BODY><P>First use the Rank Task - this will create a new columns for you with ranks.</P><P>Then use a Filter and Sort Task (or Query Builder) and filter on the new created column.</P></BODY></HTML> Mon, 04 May 2015 21:58:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filtering-a-column-based-on-top-2/m-p/209042#M15645 gergely_batho 2015-05-04T21:58:46Z