| Date: | Thu, 20 Aug 2009 13:28:04 -0700 |
|---|
| Reply-To: | Savian <savian.net@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Savian <savian.net@GMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | Re: Convert Access Datetime to SAS Datetime when Access data type
is |
|---|
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
On Aug 20, 10:11 am, Louis.Sin...@PERCEPTIVE.COM ("Sinoff, Louis")
wrote:
> I have Access MDBs coming from a machine that has the Datetime as a
> NUMBER. I can go to Access and change it to Date/Time and it Imports
> into SAS as a Datetime. My problem is that I have too many and they
> keep coming in. Can anyone give me code or formatting that will get SAS
> Datetimes from the Access NUMBER?
>
> =20
>
> =20
I am confused on the Number issue. When you says it has numbers, what
do they look like? Is this the number of ticks in the datetime/
I just checked and it appears the epochal for Access is Dec 30, 1899
at midnight (bizarre). If you have the ticks then you are going to
need to do the conversion between Access's epochal and the SAS
epochal...if I understand your question correctly.
Alan
Savian
| 
