1

How can I add months to a date? I've tried the function ADD_MONTHS(<my date>, 6) and DATEADD(Month, 6, <my date>) but both functions are not recognized.

What's the correct function to use?

paolof89
  • 1,319
  • 5
  • 17
  • 31
  • 1
    sounds like **INTNX** issue. http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_tsdata_sect038.htm – pinegulf Aug 23 '18 at 09:29

1 Answers1

1

I found an answer in sas community: function intnx()

proc sql;
    select *,intnx('month',<my_date>, 6) as incdate format=date9. from have;
quit;
paolof89
  • 1,319
  • 5
  • 17
  • 31