topic Re: Convert character to numeric to remove leading zeros in SAS Programming https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265981#M52370 <P>Does it work in proc SQL?</P> Mon, 25 Apr 2016 09:31:31 GMT Priyanshu 2016-04-25T09:31:31Z Convert character to numeric to remove leading zeros https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265974#M52366 <P>Hi</P><P>&nbsp;</P><P>How do I convert data values like 0012345678 which are in char format to 12345678, numeric format using proc sql?</P> Mon, 25 Apr 2016 09:08:01 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265974#M52366 Priyanshu 2016-04-25T09:08:01Z Re: Convert character to numeric to remove leading zeros https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265978#M52367 <P>Use the INPUT function.&nbsp;</P> Mon, 25 Apr 2016 09:26:38 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265978#M52367 Reeza 2016-04-25T09:26:38Z Re: Convert character to numeric to remove leading zeros https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265980#M52369 <P>I guess you want to check this post:</P><P>&nbsp;</P><P><A href="https://communities.sas.com/t5/Base-SAS-Programming/Function-to-remove-leading-zeros/m-p/61537#M13373" target="_blank">https://communities.sas.com/t5/Base-SAS-Programming/Function-to-remove-leading-zeros/m-p/61537#M13373</A></P><P>&nbsp;</P> Mon, 25 Apr 2016 09:30:27 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265980#M52369 Loko 2016-04-25T09:30:27Z Re: Convert character to numeric to remove leading zeros https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265981#M52370 <P>Does it work in proc SQL?</P> Mon, 25 Apr 2016 09:31:31 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265981#M52370 Priyanshu 2016-04-25T09:31:31Z Re: Convert character to numeric to remove leading zeros https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265987#M52372 <P>Yes. &nbsp;In proc sql you can use SAS functions as normal. &nbsp;Converting to number via input will automatically drop leading zeroes.</P> Mon, 25 Apr 2016 09:51:27 GMT https://communities.sas.com/t5/SAS-Programming/Convert-character-to-numeric-to-remove-leading-zeros/m-p/265987#M52372 RW9 2016-04-25T09:51:27Z