scientific notation and date issue

[SASPhile]

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.

[Doc_Duke]

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.

[sbb]

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.