topic scientific notation and date issue in SAS Programming

scientific notation and date issue

SASPhile — Wed, 26 Aug 2009 20:48:48 GMT

I'm importing data from excel. For one of the fileds I get the data in scientific notation 1.69701e+008 , the filed is saved as text,

And also in the data filed some values, I get with time part in it.The format i gave is date9.

Re: scientific notation and date issue

Doc_Duke — Thu, 27 Aug 2009 02:59:14 GMT

Please show your code and log. There are a bunch of ways to read Excel and twice that many ways for it to get confused.

Re: scientific notation and date issue

sbb — Thu, 27 Aug 2009 14:14:32 GMT

Add a useful SAS diagnostic code statement such as:

IF _N_ LT 10 THEN PUTLOG _ALL_;

and as was suggested forward the SAS log with code exposed (use COPY/PASTE into a forum post/reply) so others can help you with the problem. Of course having this information yourself may be enough to self-debug the problem.

Scott Barry
SBBWorks, Inc.