topic Re: Getting a date in the future in SAS Programming

Getting a date in the future

deleted_user — Wed, 14 Jul 2010 04:28:47 GMT

Hi All

How do I go about getting a data in the future and assigning this to a value. For example, I have to read in a list of value, e.g. A1, A2, A3 - each of these will have different due terms - e.g. A1 = Payable in 1 mth on the 25th, A2 = Payable in 2 mth on the 25th etc

So, how do I get the 25th of the following TWO and THREE months to assign to a value. I was thinking of using INTX function but don't that will work.

Thanks for your help.
Shelton.

Re: Getting a date in the future

ArtC — Wed, 14 Jul 2010 06:32:49 GMT

INTNX should do the trick. One solution might be something like:

[pre]
data adv;
date=today();
a1=1; a2=2; a3=3;
adv1 = intnx('month',date,a1)+24;
adv2 = intnx('month',date,a2)+24;
adv3 = intnx('month',date,a3)+24;
run;
[/pre]

Re: Getting a date in the future

Ksharp — Wed, 14 Jul 2010 11:55:42 GMT

Hi. INTX function has the fourth argument 'sameday' can obtain the same day after two or three months.

followdate = intnx('month',A1,2,'sameday');

Re: Getting a date in the future

deleted_user — Mon, 19 Jul 2010 04:20:23 GMT

thanks all for your help - I did the following:

IF NPAYTERM = 'A1' THEN DO;
NEXT_MON=INTNX('MONTH',DOCDATE,1) + 24;
R3DUED=PUT(NEXT_MON,YYMMDD10.);
SUBSTR(R3DUED,5,1) = '-';
SUBSTR(R3DUED,8,1) = '-';
PUT R3DUED;
END;

ELSE IF NPAYTERM = 'A2' THEN DO;
TWOMONTS=INTNX('MONTH',DOCDATE,2) + 24;
R3DUED=PUT(TWOMONTS,YYMMDD10.);
SUBSTR(R3DUED,5,1) = '-';
SUBSTR(R3DUED,8,1) = '-';
PUT R3DUED;
END;

etc etc

Thanks again.

Re: Getting a date in the future

ArtC — Tue, 20 Jul 2010 02:18:51 GMT

To show a dash as the separator consider the format yymmddd10. (notice the third d).

If all you want to do is write the value to the LOG, then you can avoid creating the variable R3DUED by using this format in the PUT statement.
[pre]
put next_mon yymmddd10.;
[/pre]

I always try to second guess the need to create a date stored in a character variable.