Date:         Thu, 20 Oct 2011 11:30:29 -0700
Reply-To:     Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Subject:      Re: Fun With Dates
Comments: To: "Keintz, H. Mark" <mkeintz@wharton.upenn.edu>
In-Reply-To:  <E0B423A8C0D1E74B8905B2C5CB38C1AF24110B@GENO3.wharton.upenn.edu>
Content-Type: text/plain; charset=ISO-8859-1

Thanks everyone!

Regarding date11. , I think that is only an informat, not a format.

Thanks for all of your input.  These are very helpful comments!

Cheers,
Mary R.

On Thu, Oct 20, 2011 at 11:24 AM, Keintz, H. Mark
<mkeintz@wharton.upenn.edu> wrote:
> As to your comment on knowing what you want the function to do, but not knowing its name:
>
> If you know the category of function you want (character string, financial, date and time) you can give yourself a fighting change with the SAS "Functions and Call Routines by Category" page.  At least then all the functions in the given category are listed consecutively.
>
> In the SAS 9.2 world, you can start at "Functions and Call Routines" (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245852.htm ) and then click on the "by Category" link.
>
> Regards,
> Mark
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mary Rosenbloom
> Sent: Thursday, October 20, 2011 2:10 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Fun With Dates
>
> Hi all,
>
> I have some variables formatted as SAS dates (date9 format), such as:
>
> IMPDT
> AWAREDT
>
> Then I have  character string, EVTDT, which has this form:
>
> 25 DEC 2011
>
> I have been asked to make all of the "dates" look alike in format.  I'm pretty sure that we need to keep the EVTDT variable as a character string, since it can sometimes contain a partial date, such as:
>
> UNK DEC 2011
>
> Questions:
> (1) Is there a date format like DATE9 but with spaces between the day and month, month and year?
>
> (2) Is there a SAS function that can remove the spaces like this:
>
> 25 DEC 2011 -> 25DEC2011
>
> I have found that it is sometimes hard to search for a function when you don't know it's name, only what it does.
>
> Thanks so much for your help!
>
> Cheers,
> Mary R.
>