topic Re: conversion from character to numeric in SAS/IML Software and Matrix Computations

conversion from character to numeric

Rasheed — Mon, 29 Sep 2014 08:42:40 GMT

I have number like 11 in character form now I have to convert it in numeric number, how can I do this

Re: conversion from character to numeric

mohamed_zaki — Mon, 29 Sep 2014 09:00:46 GMT

use input statment

like:

num = input('56',6.);

Check: Converting a Character Variable to a Numeric Variable

Re: conversion from character to numeric

Rasheed — Mon, 29 Sep 2014 09:51:43 GMT

but i have to do in proc IML and input statement is not working in IML

Re: conversion from character to numeric

Rick_SAS — Mon, 29 Sep 2014 10:34:30 GMT

Use the NUM function. You could also use the INPUTN function if you want to apply a general informat.

Re: conversion from character to numeric

Rasheed — Mon, 29 Sep 2014 13:53:26 GMT

Will this work within proc IML ?

Re: conversion from character to numeric

Rick_SAS — Mon, 29 Sep 2014 14:09:20 GMT

Yes, this is the SAS/IML forum. If it doesn't work then you should post your code so that we can see what you are trying to do.

Re: conversion from character to numeric

Rasheed — Mon, 29 Sep 2014 14:22:50 GMT

I stored value 11 in ij

and want to convert it in numeric form with width 2 and decimal place 0 and store in ijn

ijn=inputn(ij,6.<,2<,0>>);

Re: conversion from character to numeric

mohamed_zaki — Mon, 29 Sep 2014 14:38:05 GMT

ijn=input(ij, 2.0);

Re: conversion from character to numeric

Rick_SAS — Mon, 29 Sep 2014 14:43:02 GMT

Perhaps you are getting confused by the difference between informats and formats. When you use the NUM function, it uses a BEST. format to convert the characters to numbers. This is what you want to do. If you want to display the numbers with a 6.2 format, you can use the FORMAT= option on the PRINT statement, as follows:

proc iml;

x = {"1" "11" "2.135" "8" "-3.14"};

y = num(x);

print y; /* BEST format */

print y[format=6.2];/* 6.2 format */

Re: conversion from character to numeric

Rick_SAS — Mon, 29 Sep 2014 14:47:18 GMT

No, the INPUT function is not supported in SAS/IML. However, you can use the INPUTN format like this:

ijn = inputn(ij, "Best6.");

Re: conversion from character to numeric

Rasheed — Mon, 29 Sep 2014 15:00:42 GMT

I use following command and its work for me

ijn=inputn(ij,'6.',2,0);