topic How to identify bad numerical data and filter them out? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87147#M289243 <HTML><HEAD></HEAD><BODY><P>I have a dataset where some rows contain bad numerical fields which cause segmentation error when I do math operation on the variable. Does any one know how to identify them and filter them out so I can work on sound data? Thanks.</P><P>Jian</P></BODY></HTML> Wed, 18 Sep 2013 20:49:16 GMT jzhang332002 2013-09-18T20:49:16Z How to identify bad numerical data and filter them out? https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87147#M289243 <HTML><HEAD></HEAD><BODY><P>I have a dataset where some rows contain bad numerical fields which cause segmentation error when I do math operation on the variable. Does any one know how to identify them and filter them out so I can work on sound data? Thanks.</P><P>Jian</P></BODY></HTML> Wed, 18 Sep 2013 20:49:16 GMT https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87147#M289243 jzhang332002 2013-09-18T20:49:16Z Re: How to identify bad numerical data and filter them out? https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87148#M289244 <HTML><HEAD></HEAD><BODY><P>More details <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P></P><P>What is "bad numerical field"? </P><P>What is "math operation"?</P><P>What is "segmentation error"?</P><P></P><P>Is this in IML? A data step, or specific proc?</P></BODY></HTML> Wed, 18 Sep 2013 21:40:41 GMT https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87148#M289244 Reeza 2013-09-18T21:40:41Z Re: How to identify bad numerical data and filter them out? https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87149#M289245 <HTML><HEAD></HEAD><BODY><P>What kind of bad data? Examples of the code generating the errors would be helpful.</P><P></P><P>The general approach involves IF or Select statements</P><P>If the problem is divide by zero something like:</P><P>If X=0 then result=.;</P><P>Else result= var1 / x;</P><P></P><P>If values are too small or too large then similar syntax with a range check.</P><P></P><P>But could the issue be related to accessing an external database? Mostly I get errors about invalid opertions not segmentation errors.</P></BODY></HTML> Wed, 18 Sep 2013 21:45:19 GMT https://communities.sas.com/t5/SAS-Programming/How-to-identify-bad-numerical-data-and-filter-them-out/m-p/87149#M289245 ballardw 2013-09-18T21:45:19Z