|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|
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:
DDS Data Extraction
From: Mai To [mailto:Mai.To@UTH.TMC.EDU]
Sent: Wednesday, January 21, 2004 1:51 PM
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.