LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2009, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 30 Jul 2009 12:40:53 -0400
Reply-To:   Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:   Re: consistency of sorting a date or time var in num and char
Comments:   To: Ya Huang <ya.huang@AMYLIN.COM>

Ya,

Would YYYYMMDD meet your criteria?

Art ------- On Thu, 30 Jul 2009 12:33:35 -0400, Ya Huang <ya.huang@AMYLIN.COM> wrote:

>Hi there, > >Obviously sorting a date var as numeric is different from a date9. >formatted character, since '03JAN2009' is ordered after '03APR2009'. >But '03JAN2009'DT should have the same order as '01032009'. For time >var, a time5. formatted string will not have the same order as the >underline numeric var, since time5. is not zero padded. > >I wonder what kind of formatted date, time or datetime var have >the same order as the underline numeric var. > >Thanks > >Ya


Back to: Top of message | Previous page | Main SAS-L page