topic delete observations of a by group with certain property in SAS Programming https://communities.sas.com/t5/SAS-Programming/delete-observations-of-a-by-group-with-certain-property/m-p/161754#M31419 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a dataset and sorted it by five variables. One of these variables is named "DIFF". Now I would like to delete all the groups of observations, as long as one of the DIFF equals 0. (Deleting the observations with DIFF equals 0 is simple, but i would to delete the whole group as long as one of the observations has DIFF=0).</P><P></P><P>I would be very grateful for any help!</P><P></P><P>BR&nbsp; Dingdang</P></BODY></HTML> Tue, 04 Feb 2014 12:44:35 GMT Dingdang 2014-02-04T12:44:35Z delete observations of a by group with certain property https://communities.sas.com/t5/SAS-Programming/delete-observations-of-a-by-group-with-certain-property/m-p/161754#M31419 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a dataset and sorted it by five variables. One of these variables is named "DIFF". Now I would like to delete all the groups of observations, as long as one of the DIFF equals 0. (Deleting the observations with DIFF equals 0 is simple, but i would to delete the whole group as long as one of the observations has DIFF=0).</P><P></P><P>I would be very grateful for any help!</P><P></P><P>BR&nbsp; Dingdang</P></BODY></HTML> Tue, 04 Feb 2014 12:44:35 GMT https://communities.sas.com/t5/SAS-Programming/delete-observations-of-a-by-group-with-certain-property/m-p/161754#M31419 Dingdang 2014-02-04T12:44:35Z Re: delete observations of a by group with certain property https://communities.sas.com/t5/SAS-Programming/delete-observations-of-a-by-group-with-certain-property/m-p/161755#M31420 <HTML><HEAD></HEAD><BODY><P>proc sql;</P><P>delete from work.have</P><P>where group in (select group from work.have where diff=0);</P><P>quit;</P></BODY></HTML> Tue, 04 Feb 2014 13:11:26 GMT https://communities.sas.com/t5/SAS-Programming/delete-observations-of-a-by-group-with-certain-property/m-p/161755#M31420 DBailey 2014-02-04T13:11:26Z