DATA Step, Macro, Functions and more

scientific notation and date issue

Reply
Super Contributor
Posts: 673

scientific notation and date issue

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.
Trusted Advisor
Posts: 2,116

Re: scientific notation and date issue

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: scientific notation and date issue

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.
Ask a Question
Discussion stats
  • 2 replies
  • 136 views
  • 0 likes
  • 3 in conversation