https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5342#M2160 hi<BR /> <BR /> I have data field like this<BR /> <BR /> item_id<BR /> 1.0070311E30<BR /> <BR /> how to i convert this Scientic value to normal value<BR /> <BR /> i.e. 1007031060700020030001703070251<BR /> <BR /> <BR /> i.e this(1007031060700020030001703070251) is the actual value of the above(1.0070311E30) value<BR /> i import the data from text file to SAS .<BR /> but i want actual value<BR /> how to i convert to normal value...<BR /> <BR /> thnx.<BR /> cnu.. Fri, 02 Nov 2007 08:08:31 GMT deleted_user 2007-11-02T08:08:31Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5342#M2160 hi<BR /> <BR /> I have data field like this<BR /> <BR /> item_id<BR /> 1.0070311E30<BR /> <BR /> how to i convert this Scientic value to normal value<BR /> <BR /> i.e. 1007031060700020030001703070251<BR /> <BR /> <BR /> i.e this(1007031060700020030001703070251) is the actual value of the above(1.0070311E30) value<BR /> i import the data from text file to SAS .<BR /> but i want actual value<BR /> how to i convert to normal value...<BR /> <BR /> thnx.<BR /> cnu.. Fri, 02 Nov 2007 08:08:31 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5342#M2160 deleted_user 2007-11-02T08:08:31Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5343#M2161 import the value of item_ID as text not number. <BR /> SAS number values have only 16-18 digits precision.<BR /> <BR /> PeterC Fri, 02 Nov 2007 09:05:09 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5343#M2161 deleted_user 2007-11-02T09:05:09Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5344#M2162 From SAS online documentation Informats <BR /> Ew.d Informat reads numeric values that are stored in scientific notation and double-precision scientific notation <BR /> <BR /> However, if your source data is displaying only 1.70123E30, you cannot get the remaining digits of precision because they do not exist in your source data. Mon, 05 Nov 2007 15:22:58 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5344#M2162 advoss 2007-11-05T15:22:58Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5345#M2163 Thanks.,<BR /> <BR /> I Done succesessfully Tue, 06 Nov 2007 06:08:43 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hoe-to-convert-the-Scientific-value-to-normal-value/m-p/5345#M2163 deleted_user 2007-11-06T06:08:43Z