topic dates in New SAS User

dates

Ela_84 — Tue, 21 Jan 2020 13:50:01 GMT

Hi guys,

I need to populate a field called next instalment date and the field I'm have is current instalment date in the format date9. e.g 21Dec2019, I need to populate a field next instalment date using the current instalment date, I needs to display as 21Jan20.

Please can someone advice where to start?

Re: dates

Kurt_Bremser — Tue, 21 Jan 2020 13:52:49 GMT

If you want to get the same day in the next month, use

nextdate = intnx('month',curdate,1,'s');

Re: dates

Ela_84 — Tue, 21 Jan 2020 14:01:04 GMT

Hi Kurt,

this looks like it might work, I ran the statement

nextdate = intnx('month',InstalmentDate,1,'s');

however it populates a Numeric field and not in a date format. I might be using the code incorrect. I apologies, but I'm very new and teaching myself the coding.

Re: dates

Kurt_Bremser — Tue, 21 Jan 2020 14:12:23 GMT

If you create a new variable, you need to assign a date display format to make the result of the calculation human-readable. A SAS date value is a count of days from 1960-01-01, so today's date is 21935.

Add this to the code

format nextdate date9.;

and you'll get the "default" SAS date format. Others can be found in the documentation (section Date and Time).

Re: dates

Ela_84 — Tue, 21 Jan 2020 14:19:12 GMT

hi Kurt,

I have tried this code and it works perfect!

INTNX('MONTH',InstalmentDate,+1,'SAMEDAY') AS nextdate FORMAT = Date9.

Thank you for great help, you lead me to this 🙂

Regards,