topic Re: macro help in SAS Enterprise Guide

macro help

rebeccas — Thu, 02 Nov 2017 14:06:01 GMT

What is wrong with this?

This is what my output looks like rather than 30sep2017:

example is intnx('month',21063,0,'e')

%let yymm = 1709;

%let example = intnx('month',%sysfunc(inputn(&yymm.,yymmn4.)),0,'e');

%put example is &example.;

Re: macro help

data_null__ — Thu, 02 Nov 2017 14:12:55 GMT

You need another sysfunc.

27         %let yymm = 1709;
28         %let example = %sysfunc(intnx(month,%sysfunc(inputn(&yymm.,yymmn4.)),0,e),date9);
29         %put example is &example.;
example is 30SEP2017