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 (November 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 5 Nov 2009 16:10:09 -0800
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: Converting yyyymmdd
In-Reply-To:  <a7fa8190-11ab-46b8-8594-9bd06c341912@u13g2000vbb.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

You said you had a numeric date variable. 20091005 is not a numeric date variable as SAS uses the term. You can convert that value to a date value with the expression INPUT(PUT(your-numeric-variable,8.),YYMMD8.)

If the value does not have time, why do you want a DATETIME19. format instead of one of the date formats?

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Sdlentertd Sent: Thursday, November 05, 2009 2:08 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Converting yyyymmdd

On Nov 5, 1:22 pm, barry.a.schw...@BOEING.COM ("Schwarz, Barry A") wrote: > The PUT function will convert the numeric value to character. > > The YEAR and MONTH functions will extract the corresponding values from a date value. > > > > -----Original Message----- > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of Sdlentertd > Sent: Thursday, November 05, 2009 11:46 AM > To: SA...@LISTSERV.UGA.EDU > Subject: Converting yyyymmdd > > I would like to do two things to yyyymmdd NUMERIC date. > > 1)convert numeric yyyymmdd into DATETIME19. character. > > 2) extract Month and year from NUMERIC yyyymmdd so Month will by > numeric ( 1 2 3 4...) and the year would be numeric (2001 2003 2007 > etc.) > > Thank you.- Hide quoted text - > > - Show quoted text -

THIS STATEMENT DOES NOT WORK dt = dhms(sasdate,0,0,0); This date 20091005 shows up as 1570320000 and not what I need 05OCT2009:00:00:00


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