Date:         Mon, 1 Oct 2007 19:38:18 -0500
Reply-To:     OR Stats <stats112@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         OR Stats <stats112@GMAIL.COM>
Subject:      Re: Txt to Date SAS
Comments: To: Samuel Croker <samuel.croker@gmail.com>
In-Reply-To:  <685b29a0709281227n6b963362rcd344d94f0e6e6e@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Yes, that's true...  And how would one run date range queries from this new
variable then?  I presume I could use PROC SQL; however, the comparative
range should be in what format then?

Moreover, if I would generate a time series graph based on my new variable
and print only MonYY, what is the customization syntax I need in SAS to
exclude the artificial 'day' in the x-axis?

Cheers!


On 9/28/07, Samuel Croker <samuel.croker@gmail.com> wrote:
>
> Yes, but remember that Jan07 read in with the mmyyy5. informat becomes
> 17167 or 01JAN2007  so take this into account.  Toby's method also
> would do this same thing without the informat.
>
> HTH,
>
> Sam
>
> On 9/28/07, OR Stats <stats112@gmail.com> wrote:
> > Thanks everyone!  With its reformate to a proper date variable, then my
> > MMMYY variable is date range queriable, correct?  Have a great weekend,
> > ORstats
> >
> > On 9/26/07, Pardee, Roy <pardee.r@ghc.org> wrote:
> > >
> > > Try the input() function with the anydtdte. format.
> > >
> > > HTH,
> > >
> > > -Roy
> > >
> > > -----Original Message-----
> > > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> OR
> > > Stats
> > > Sent: Wednesday, September 26, 2007 5:23 AM
> > > To: SAS-L@LISTSERV.UGA.EDU
> > > Subject: Txt to Date SAS
> > >
> > > Hello All:  I am interested in converting MMMYY txt into Date format.
> > > Currently the txt field is populated as Jan01 to Aug07 from external
> > > source.  However, I would like to make that field recognizable to SAS
> as
> > > a date field so that the resulting numerical interpretation of the
> MMMYY
> > > may be used in a time dependent model in SAS.  Thanks so
> much!  Orstats
> > >
> >
>
>
> --
> Samuel T. Croker
> Lexington, SC & Bethesda, MD
>