Date: Wed, 29 Aug 2007 15:31:49 -0400
Reply-To: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject: Re: Date format
On Wed, 29 Aug 2007 19:11:16 +0000, toby dunn <tobydunn@HOTMAIL.COM> wrote:
>Im gonna jump in here and say this first find out if th evariable is a SAS
>Date or DateTime value. It is possible to format a SAS Date value with
But that invariably maps to a time during 1 Jan. 1960, which is not what we
>The time being all 0's concerns me enough to promt you to
>atleast find this out before you go any further.
>Comprimise is like telling a lie, it gets easier and easier. Each
>comprimise you make, that becomes your standard.
>Perfection doesnt exist, once you reach it, its not perfect anymore. It
>means something else.
>From: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
>Reply-To: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
>Subject: Re: Date format
>Date: Wed, 29 Aug 2007 12:04:25 -0700
>No, the value is stored as the number of seconds since
>'01JAN1960:00:00:00 'dt, independent of how it appears in the output.
>The variable in question apparently has the format datetime18.
>associated with it which only controls how it is printed by default.
>If you want only the date part of the value, you have at least two
> 1 - When printing the value, specify the datetime9. format.
>This will override the default format and truncate the output to the
>first nine characters.
> 2 - Extract the date portion of the value with the datepart
>function and print this with the date9. format.
>From: sas biology [mailto:snip]
>Sent: Wednesday, August 29, 2007 10:51 AM
>Subject: Date format
>The date value in one of my date sets is stored in the format '
>18JUL2005:00:00:00'. But I want to change it to '18JUL2005' format. How
>I do that?
>Tease your brain--play Clink! Win cool prizes!