Desktop productivity for business analysts and programmers

macro help

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

macro help

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.;


Accepted Solutions
Solution
‎11-02-2017 10:13 AM
Respected Advisor
Posts: 3,834

Re: macro help

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

View solution in original post


All Replies
Solution
‎11-02-2017 10:13 AM
Respected Advisor
Posts: 3,834

Re: macro help

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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 151 views
  • 0 likes
  • 2 in conversation