Well, is that a date format? Can it be done without concatenating the quotes and d?. Your question was, what dateformat would return the value in the format '22Jun2003'd ? with quotes and D, all of it? ^^^^^^^^^^^^^ Prasad Ravi Arto Raiskio <arto@RAISKIO.COM> To: SAS-L@LISTSERV.UGA.EDU Sent by: "SAS(r) cc: Discussion" Subject: Re: datepart autoformat in a macro <SAS-L@LISTSERV.UGA.E DU> 06/23/2003 12:33 PM Please respond to Arto Raiskio "Prasad S Ravi" wrote > I don't recall any dateformat which will do that for you. rob abelson suggested this and it appears to do the trick a = "'" ||put( intnx ( 'day', date(), -1), date9. )||"'d";