https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704005#M26083 <P>Dear Colleagues</P> <P>Would be kind enough to crack this for me? Tx</P> <P>I have a numerical value with decimal places. I would like to ignore the decimal places so that the new variable (want) has looks (and is equal to) the original variable after ignoring the decimal place. Kindly see an example of&nbsp; the data i have versus what i want;</P> <P>Have&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Want <BR />23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23<BR />22.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 221<BR />0.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9<BR />2.23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 223<BR />1.011&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1011<BR />0.0001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<BR />9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9</P> <P>&nbsp;</P> <P>Thank you so much</P> <P>&nbsp;</P> <P>Dathan&nbsp;</P> Mon, 07 Dec 2020 01:13:37 GMT DathanMD 2020-12-07T01:13:37Z https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704005#M26083 <P>Dear Colleagues</P> <P>Would be kind enough to crack this for me? Tx</P> <P>I have a numerical value with decimal places. I would like to ignore the decimal places so that the new variable (want) has looks (and is equal to) the original variable after ignoring the decimal place. Kindly see an example of&nbsp; the data i have versus what i want;</P> <P>Have&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Want <BR />23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23<BR />22.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 221<BR />0.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9<BR />2.23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 223<BR />1.011&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1011<BR />0.0001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<BR />9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9</P> <P>&nbsp;</P> <P>Thank you so much</P> <P>&nbsp;</P> <P>Dathan&nbsp;</P> Mon, 07 Dec 2020 01:13:37 GMT https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704005#M26083 DathanMD 2020-12-07T01:13:37Z https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704007#M26084 <P>data want;</P> <P>&nbsp;&nbsp;&nbsp; set have;</P> <P>&nbsp;&nbsp;&nbsp; y = input(compress(put(x,best10.),'.'),10.);</P> <P>run;</P> Mon, 07 Dec 2020 01:23:33 GMT https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704007#M26084 PaigeMiller 2020-12-07T01:23:33Z https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704020#M26093 <P>Thank you&nbsp;<SPAN>&nbsp;</SPAN><A class="trigger-hovercard" href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892" target="_blank">PaigeMiller</A>!</P> Mon, 07 Dec 2020 02:15:30 GMT https://communities.sas.com/t5/New-SAS-User/Ignoring-decimal-places/m-p/704020#M26093 DathanMD 2020-12-07T02:15:30Z