Date:         Mon, 19 May 2008 04:08:00 -0700
Reply-To:     Nanita <susana.urbano@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nanita <susana.urbano@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Summing months in dates
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On 19 Maio, 11:45, RolandRB <rolandbe...@hotmail.com> wrote:
> On May 19, 12:27 pm, Nanita <susana.urb...@gmail.com> wrote:
>
>
>
> > Hi there,
>
> > I'me havind some trouble summing some dates.
>
> > I have a table with a column with Begin_Date and another colunm with
> > Maturity_Lenght.
>
> > I need to create another column with the End_Date, by adding the
> > Maturity_Lenght to the Begin_Date.
>
> > Begin_Date         Maturity_Lenght (month)            End_Date
>
> > 02-05-2008                        1
> > 02-06-2008
>
> > 05-05-2008                        3
> > 05-08-2008
> >                                   .....
>
> > How can I do that?
>
> > Thank you so much.
>
> In the following case I am adding 3 months to dt to get dt2.
>
> 13   data _null_;
> 14     format dt dt2 date9.;
> 15     dt="05jun2008"d;
> 16     dt2=mdy(month(dt)+3,day(dt),year(dt));
> 17     put dt2=;
> 18   run;
>
> dt2=05SEP2008
> NOTE: DATA statement used:
>       real time           0.00 seconds
>       cpu time            0.00 seconds

Thanks you for you answer.

But I'm trying to do something like that, and it doesn't work:

data mylib.txcp_copy;
SET mylib.txcurtoprazo;
IF      Prazo='D01'     THEN DO
        End_Date=Begin_date+1;
        END;
IF      Prazo='D07'     THEN DO
        End_Date=Begin_date+7;
        END;
IF      Prazo='D14' THEN DO
        End_Date=Begin_date+14;
END;

/* I want that every End_dates of a data with Prazo = M03 it's a sum
of Begin_date plus 3*/
IF      Prazo='M03'     THEN DO
        End_Date=mdy(month(Begin_date)+3,day(Begin_date),year(Begin_date));
        END;
run;