| Date: | Wed, 21 Jan 2004 14:13:43 -0800 |
|---|
| Reply-To: | "Choate, Paul@DDS" <pchoate@DDS.CA.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Choate, Paul@DDS" <pchoate@DDS.CA.GOV> |
|---|
| Subject: | Re: Excel date |
|---|
Mia-
It should import as the number 15584, this is the number of days from
1/1/1960 to 9/1/2002. Format this date in SAS with the MMDDYY8. format and
it will look like 09/01/02 again.
Read about SAS dates here:
http://v8doc.sas.com/sashtml/lrcon/z1112342.htm
(User:SAS Pwd:onlinedoc)
Paul Choate
DDS Data Extraction
(916) 654-2160
-----Original Message-----
From: Mai To [mailto:Mai.To@UTH.TMC.EDU]
Sent: Wednesday, January 21, 2004 1:51 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Excel date
I import an Excel file with the date shown as 09/01/02.
How should I format the date field so it can shown as above.
Thanks.
Mia
| 
