topic Convert EXP value in SAS Programming

Convert EXP value

Kwok — Wed, 21 Apr 2010 12:44:08 GMT

Hi,

Do you know what is the SAS function or routine that can convert a string such as
7.8E+5 or 000078E-5 into the correct numeric values with decimal places? I tried the EXP function but the base values already defined e.

Thanks
Kwok

Re: Convert EXP value

Doc_Duke — Wed, 21 Apr 2010 12:56:14 GMT

Checkout the "E" informat.

Re: Convert EXP value

deleted_user — Wed, 21 Apr 2010 13:45:29 GMT

Hi,Kwok
Here is the codes:
data _null_;
p='7.8E+5';
o=input(p,12.2);
put p o;
run;

Re: Convert EXP value

Kwok — Wed, 21 Apr 2010 16:33:21 GMT

Thanks for your code. But how do you determine the 12.2 ? If the data stream variable E formay such as 7.8E+5, 7.8E-7, 8.1005E+13 ..., how would you define the informat value ?

Thanks

Re: Convert EXP value

Tim_SAS — Wed, 21 Apr 2010 17:10:21 GMT

Generally you don't have to. If the data contain decimal points the decimal value is ignored. Here's the doc: http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a000204411.htm.

Re: Convert EXP value

Kwok — Wed, 21 Apr 2010 18:30:16 GMT

Thanks Tim,