topic Re: Extracting all rows where the numeric values are larger than 0 in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81380#M736 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i see that the values in the column are aligned to the left, as you know character values are aligned to the left and numeric values are aligned to the right. So i believe the values of column Differanse are character. Try to convert them into numeric and then try what you have mentioned in the post above. </P><P></P><P>or else you can use Differanse^="0,00". Hope this helps you.</P><P></P><P>Thanks,<BR />Jagadish</P></BODY></HTML> Tue, 22 Jan 2013 07:25:24 GMT Jagadishkatam 2013-01-22T07:25:24Z Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81377#M733 <HTML><HEAD></HEAD><BODY><P>This seems like a silly question, but given that I have these numeric values...</P><P></P><P><IMG alt="1.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/3004_1.PNG" /></P><P></P><P>... why can't I use this in order to extract all rows withere Differanse is higher than 0?</P><P></P><P><IMG alt="2.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/3005_2.PNG" /></P><P></P><P>When I try that, it just extracts all rows. I've also tried Differanse &gt; 0, with the same lack of result.</P></BODY></HTML> Mon, 21 Jan 2013 21:52:39 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81377#M733 EinarRoed 2013-01-21T21:52:39Z Re: Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81378#M734 <HTML><HEAD></HEAD><BODY><P>Try &gt;0.1.</P><P>You probably have some floating point errors going on, where the number is actually 0.000001 but displaying as 0.00. </P><P></P><P>There are other options if you can't use the above method as well.</P></BODY></HTML> Mon, 21 Jan 2013 22:14:01 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81378#M734 Reeza 2013-01-21T22:14:01Z Re: Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81379#M735 <HTML><HEAD></HEAD><BODY><P>Also if you use not equal to zero you'll get any negative numbers and missing as well as positive numbers</P></BODY></HTML> Mon, 21 Jan 2013 23:25:48 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81379#M735 twocanbazza 2013-01-21T23:25:48Z Re: Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81380#M736 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i see that the values in the column are aligned to the left, as you know character values are aligned to the left and numeric values are aligned to the right. So i believe the values of column Differanse are character. Try to convert them into numeric and then try what you have mentioned in the post above. </P><P></P><P>or else you can use Differanse^="0,00". Hope this helps you.</P><P></P><P>Thanks,<BR />Jagadish</P></BODY></HTML> Tue, 22 Jan 2013 07:25:24 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81380#M736 Jagadishkatam 2013-01-22T07:25:24Z Re: Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81381#M737 <HTML><HEAD></HEAD><BODY><P>Consider how this columns gets populated. Integers (including zero) should normally work properly with such conditions.</P><P>You may want to use the round() function to get control of your data.</P></BODY></HTML> Tue, 22 Jan 2013 11:47:02 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81381#M737 LinusH 2013-01-22T11:47:02Z Re: Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81382#M738 <HTML><HEAD></HEAD><BODY><P>Jagadish</P><P></P><P>Looking at the column header and the image (from DIS) it is a numeric field with a format applied (which is probably aligning to the left)</P><P></P><P>Barry</P></BODY></HTML> Tue, 22 Jan 2013 19:46:31 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81382#M738 twocanbazza 2013-01-22T19:46:31Z Re: Extracting all rows where the numeric values are larger than 0 https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81383#M739 <HTML><HEAD></HEAD><BODY><P>i agree with you Barry, did not observe that.</P><P></P><P>Thanks</P><P>Jagadish</P></BODY></HTML> Wed, 23 Jan 2013 03:41:05 GMT https://communities.sas.com/t5/SAS-Data-Management/Extracting-all-rows-where-the-numeric-values-are-larger-than-0/m-p/81383#M739 Jagadishkatam 2013-01-23T03:41:05Z