Date:         Wed, 30 Oct 2002 11:42:22 -0000
Reply-To:     "roland.rashleigh-berry" <roland.rashleigh-berry@NTLWORLD.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "roland.rashleigh-berry" <roland.rashleigh-berry@NTLWORLD.COM>
Organization: ntlworld News Service
Subject:      Re: HOWTO find last Friday of month?

Will this do it?

Use the date of the first of the following month and apply this.

lastfri=intnx('week.6',date-1,0);


"Stig Eide" <stigeide@yahoo.com> wrote in message
news:faa59d77.0210300300.2fef0ad4@posting.google.com...
> Does anyone have a tip of how to find the last Friday of a month?
>
> The last day of the month can be found with the INTNX function:
>   lastDay=intnx('month',today(),0,'E');
> This gives the SAS date value of the last day of the current month.
>
> Anyone have a suggestion?
>
> Thanks!
> Stig Eide