Date:         Wed, 17 Jul 2002 10:52:46 -0700
Reply-To:     Pete Lund <pete.lund@NWCSR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Pete Lund <pete.lund@NWCSR.COM>
Subject:      Re: MS Access to SAS Date Interpretation
Comments: To: Cathy Ward <cward@NCACCESSCARE.ORG>
In-Reply-To:  <000c01c22db9$05eb94c0$1001a8c0@accesscare.intranet>
Content-Type: text/plain; charset="us-ascii"

Hi Cathy-
  Try the DATE9. informat when reading those string date values.

----------------------------------------------------------------------------
---
Pete Lund
Northwest Crime and Social Research, Inc.
A SAS Alliance Partner
215 Legion Way SW
Olympia, WA   98501
(360) 528-8970  - voice
(360) 280-4892  - cell
(360) 570-7533  - fax
pete.lund@nwcsr.com
www.nwcsr.com
----------------------------------------------------------------------------
---



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
Cathy Ward
Sent: Wednesday, July 17, 2002 10:40 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: MS Access to SAS Date Interpretation


I received a data set from an external source, created by a 6.12 ver of
SAS, which in turn was exported into an MS Access table.  The dates are
listed in a DDMMMYY format, and as MS Access uses different
nomenclature, are stored as character rather than date/time variables.
I am now trying to import these data sets into my ver 8 SAS and am
having trouble getting these fields to be recognized as dates.  Any
suggestions as to how to convert these character values to a date SAS
recognizes would be much appreciated.

Kind regards,

Catherine Ward, RN, MSN/MBA
Clinical Data Analyst
3500 Gateway Centre Boulevard, Suite 130
Morrisville, NC 27560-8501
Phone: (919) 380-9962/Fax: (919) 468-8573
CWard@ncaccesscare.org