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 >