Date:         Wed, 6 Nov 2002 13:22:54 +0100
Reply-To:     Jan Selchau-Hansen <jan@*SELCHAU-HANSEN.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jan Selchau-Hansen <jan@*SELCHAU-HANSEN.DK>
Organization: TDC Internet
Subject:      Re: Dates and Months

Graeme,

This will work in most cases.
It may give you an idea how to work whith sas-dates.

Jan Selchau-Hansen


data test;
 curdate=today();
 p3mon=intnx('MONTH',curdate,-3)+day(curdate)-1;
format curdate p3mon ddmmyy10. ;
run;

<Graeme.Kirton@FILCS.COM> skrev i en meddelelse
news:OFE265BF4F.6782E798-ON80256C69.004041F5-80256C69.00403B22@fcs.com...
> Hi, Im needing to programmatically calculate the date to give the last
> three month period.  So I end up with two variables;
>
> curdate= today;
> p3months= 6AUG02
>
> Any ideas???
>
> Thankyou
>
> --------------------------------------------------------------
> Graeme Kirton
> IT Developer
> Filtronic Compound Semiconductors Ltd