Date: Wed, 14 Jan 2004 20:15:56 GMT
Reply-To: bogdan romocea <br44092@GAWAB.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: bogdan romocea <br44092@GAWAB.COM>
Subject: Re: Date format question
Content-Type: text/plain; charset="iso-8859-1"
What you probably want to do is transform both dates in SAS
format (if applicable).
What do you actually have in your data set - dates in SAS
format, or text in date9 format? 01FEB1900 may be in fact a SAS
date, displayed this way because the format is saved in your
data set. In the same way, is 1900-02-01 a SAS date or text? If
you have text use an informat to input those dates in SAS
format, and then you can easily do your comparisons.
Check this for details:
Dasappan, Michael writes:
> I have a dataset with dates in this format DATE9 (01FEB1900) I need to
> convert this to a char(10) format eventually making this into data that
> looks like '1900-02-01' to compare this to other information. Any
> suggestions will be appreciated.
> This e-mail message and any attachments contain confidential information from Medco Health Solutions, Inc. If you are not the intended recipient, you are hereby notified that disclosure, printing, copying, distribution, or the taking of any action in reliance on the contents of this electronic information is strictly prohibited. If you have received this e-mail message in error, please immediately notify the sender by reply message and then delete the electronic message and any attachments.
15 Mbytes Free Web-based and POP3
Sign up now: http://www.gawab.com