Date:         Wed, 21 Jan 2009 06:31:56 -0500
Reply-To:     Nathaniel.Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject:      Re: Date with time - import from excel
In-Reply-To:  <7b22082d-a3b5-42c4-9700-d31793048485@v5g2000prm.googlegroups.com>
Content-Type: text/plain; charset="US-ASCII"

On your set statement, add a SASDATEFMT option as I did in the line below.
Hopefully, this will fix the problem.


     set FISHi.'FISHgeneric$'n   (sasdatefmt=( datetime ='datetime16.')) ;

Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977



             bufino
             <qotsa79@HOTMAIL.
             CO.UK>                                                     To
             Sent by: "SAS(r)          SAS-L@LISTSERV.UGA.EDU
             Discussion"                                                cc
             <SAS-L@LISTSERV.U
             GA.EDU>                                               Subject
                                       Date with time - import from excel

             01/21/2009 06:12
             AM


             Please respond to
                  bufino
             <qotsa79@HOTMAIL.
                  CO.UK>






Hi guys.

I'm importing a file from excel and the date is in this format
12/01/2000 15:34.

I need the time but when I import the file even if I specify that is a
16 digit date SAS imports it wrongly and it gives me a wrong date.

Can anyone advise on how to import it correctly?

Cheers All.


CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.