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 (December 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 2 Dec 2008 15:37:57 -0600
Reply-To:   Joe Matise <snoopy369@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Joe Matise <snoopy369@GMAIL.COM>
Subject:   Re: SDTM Partial dates
Comments:   To: SAS_learner <proccontents@gmail.com>
In-Reply-To:   <c2192a610812021249w7d64a19eq548a1c2c08b74e8b@mail.gmail.com>
Content-Type:   text/plain; charset=ISO-8859-1

You could define month and/or day as 1, if that is appropriate for your data needs, when they are left out (2008 -> 1/1/2008, 5/2008 -> 5/1/2008)...

If the date is in a numeric format, it cannot be missing a month (numeric Date = days since a particular day, IIRC 1/1/1960 for SAS). If you mean character format with numbers inside, then you would have to make reasonable guesses for what is missing (is 092008 Sept. 2008 (no date), or 9/20/2008, or julian 1/9/2008, or something else?)

-Joe

On Tue, Dec 2, 2008 at 2:49 PM, SAS_learner <proccontents@gmail.com> wrote:

> Hello _all_, > > May be some body have already might have asked this one. What I am doing is > getting the dates into SDTM format . I do not have any problem when I have > complete date . When I have the Complete date I am doing something like > this > > > Dmdlstd2 = Put ( Dmdlstd,IS8601DA. ); > > But does this Format would when there are Partial dates that missing date > and missing Month ?? if not is there simple way check Dmdlstd when it is > Num. > > I do have macro where I would cut the Character Dmdlstd into Parts and set > it back with assigning format to Month. Is there better way > > thanks for your time and Thoughts (TTT) > SL >


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