topic removing an observation in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90113#M25717 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to find the mean for one of my variables, but that variable has one outlier observation.</P><P></P><P>How can I find the mean of that variable without that one observation with PROC MEAN.</P><P></P><P>Thank you</P></BODY></HTML> Tue, 09 Oct 2012 17:29:09 GMT R_A_G_ 2012-10-09T17:29:09Z removing an observation https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90113#M25717 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to find the mean for one of my variables, but that variable has one outlier observation.</P><P></P><P>How can I find the mean of that variable without that one observation with PROC MEAN.</P><P></P><P>Thank you</P></BODY></HTML> Tue, 09 Oct 2012 17:29:09 GMT https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90113#M25717 R_A_G_ 2012-10-09T17:29:09Z Re: removing an observation https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90114#M25718 <HTML><HEAD></HEAD><BODY><P>how about using the where clause.</P><P></P><P>PROC MEANS DATA=_LAST_(where=(myvar ^= xxx));</P><P>...</P><P></P><P>Doc Muhlbaier</P><P>Duke</P></BODY></HTML> Tue, 09 Oct 2012 19:03:19 GMT https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90114#M25718 Doc_Duke 2012-10-09T19:03:19Z Re: removing an observation https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90115#M25719 <HTML><HEAD></HEAD><BODY><P>I want to eliminate a specific observation from a specific sets of variable. Not really eliminate but rather exclude from the analysis. </P></BODY></HTML> Tue, 09 Oct 2012 21:16:54 GMT https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90115#M25719 R_A_G_ 2012-10-09T21:16:54Z Re: removing an observation https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90116#M25720 <HTML><HEAD></HEAD><BODY><P>thank you Doc, it actually worked.</P><P></P><P>PROC MEANS DATA=data(where=(people^='Jim' ));var item1; Run;</P></BODY></HTML> Tue, 09 Oct 2012 21:24:53 GMT https://communities.sas.com/t5/SAS-Procedures/removing-an-observation/m-p/90116#M25720 R_A_G_ 2012-10-09T21:24:53Z