| 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 |
|
| 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
>
|