https://communities.sas.com/t5/SAS-Enterprise-Guide/delete-observations/m-p/990#M285 You can follow these steps :<BR /> <BR /> 1) create a query on your dataset<BR /> 2) in the SELECT/SORT tab, keep all the columns you need at the end<BR /> 3) in this tab, choose a <GROUP> value in the SIGMA drop-down list (just right to the check boxes) for the variable of which you want to use frequencies<BR /> 4) drag and drop one more time this particular variable in the SELECT/SORT TAB, and give it a <COUNT> value in the SIGMA list<BR /> 5) rename this last column COUNT<BR /> 6) go to the GROUP FILTERS tab, and build a condition using the newly created COUNT variable (should be at the very bottom of the list on the left).<BR /> <BR /> I hope it solves your problem.</COUNT></GROUP> Tue, 11 Jul 2006 13:19:05 GMT Olivier 2006-07-11T13:19:05Z https://communities.sas.com/t5/SAS-Enterprise-Guide/delete-observations/m-p/989#M284 Hi, <BR /> i want to delete observations by their frequency. I don't know if I need to do a proc freq and then to do the deletion base on the results...<BR /> <BR /> Thanks, Fri, 07 Jul 2006 16:31:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/delete-observations/m-p/989#M284 deleted_user 2006-07-07T16:31:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/delete-observations/m-p/990#M285 You can follow these steps :<BR /> <BR /> 1) create a query on your dataset<BR /> 2) in the SELECT/SORT tab, keep all the columns you need at the end<BR /> 3) in this tab, choose a <GROUP> value in the SIGMA drop-down list (just right to the check boxes) for the variable of which you want to use frequencies<BR /> 4) drag and drop one more time this particular variable in the SELECT/SORT TAB, and give it a <COUNT> value in the SIGMA list<BR /> 5) rename this last column COUNT<BR /> 6) go to the GROUP FILTERS tab, and build a condition using the newly created COUNT variable (should be at the very bottom of the list on the left).<BR /> <BR /> I hope it solves your problem.</COUNT></GROUP> Tue, 11 Jul 2006 13:19:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/delete-observations/m-p/990#M285 Olivier 2006-07-11T13:19:05Z