creating end date variable inside sas macro using intnx

[ballardw · Accepted solution]

The macro processor treats everything as text so the quotes aren't needed in this call to intnx

%let end_date=%sysfunc(intnx(month,&date, 0, end));

%put &end_date;

This kind of debugging is another reason to process such things in a datastep if at all possible.

[vsharipriya]

Thanks @ballardw, this works.