LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 23 Jun 2003 22:00:39 +0300
Reply-To:   Arto Raiskio <arto@RAISKIO.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Arto Raiskio <arto@RAISKIO.COM>
Subject:   datepart autoformat in a macro

section of a macro executes an item that appears as

a = put( intnx ( 'day', date(), -1), mmddyy6. );

this returns to a macrovariable in another section today-1, ie. 062203

question is, what dateformat would return the value in the format '22Jun2003'd ? with quotes and D, all of it?

pseudocode: a = put( intnx ( 'day', date(), -1), ddMMMyyyy. );

this code is passed on to a Proc SQL which extracts data in the format

..and (datepart('01jan70:00:00:00'dt+A.occurrance) = '22jun2003'd )


Back to: Top of message | Previous page | Main SAS-L page