topic Re: Char to Numeric conversion in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Char-to-Numeric-conversion/m-p/115843#M32024 <HTML><HEAD></HEAD><BODY><P>Assuming none of your variables are missing something like:</P><P></P><P>Var1 = input(scan(yourtextvariablenamehere,1),best8.);</P><P>Repeat for the expected number of variables. If there are many an array might help.</P></BODY></HTML> Mon, 22 Apr 2013 21:25:23 GMT ballardw 2013-04-22T21:25:23Z Char to Numeric conversion https://communities.sas.com/t5/SAS-Procedures/Char-to-Numeric-conversion/m-p/115842#M32023 <HTML><HEAD></HEAD><BODY><P>I have a charecter variable</P><P>The column attributes are</P><P>length 200</P><P>format $200</P><P></P><P>The values are something like 101.1&nbsp; 106.7</P><P>How can i convert these to numeric values so that I can use in analysis????</P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 22 Apr 2013 18:54:39 GMT https://communities.sas.com/t5/SAS-Procedures/Char-to-Numeric-conversion/m-p/115842#M32023 robertrao 2013-04-22T18:54:39Z Re: Char to Numeric conversion https://communities.sas.com/t5/SAS-Procedures/Char-to-Numeric-conversion/m-p/115843#M32024 <HTML><HEAD></HEAD><BODY><P>Assuming none of your variables are missing something like:</P><P></P><P>Var1 = input(scan(yourtextvariablenamehere,1),best8.);</P><P>Repeat for the expected number of variables. If there are many an array might help.</P></BODY></HTML> Mon, 22 Apr 2013 21:25:23 GMT https://communities.sas.com/t5/SAS-Procedures/Char-to-Numeric-conversion/m-p/115843#M32024 ballardw 2013-04-22T21:25:23Z