1. %SYSFUNC() is needed on every function (INPUTN and INTNX)
2. But, %SYSFUNC() also has a second parameter that acts as the format so you don't need the INPUTN actually.
3. You were referencing start instead of date_start in the third calculation, but I think you really wanted the date_start macro variable that's a SAS date instead.
Or nest all together of course.
%let start=1909;/*YYMM*/
%put &start;
%let date_start=%sysfunc(inputn(&start,yymmn4.));
%put &date_start;
%let t=%sysfunc(intnx(month, &date_start, -2, s), yymmn4.);
%put &t;
@Ronein wrote:
Hello
User define macro parameter with %let in format of YYMM.
I know how to create a new macro parameter that is sas date(numeric number that represent number of days since 1.1.1960)
My question:
I want to create a SAS date (number of days since 1.1.1960) of 2 months before &start.
However it is not working and I receive an error and also the value that I get is null.
WARNING: Argument 1 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.
%let start=1909;/*YYMM*/
%put &start;
%let date_start=%sysfunc(inputn(&start,yymmn4.));
%put &date_start;
%let t=%sysfunc(inputn(intnx('month',&start,-2),yymmn4.));
%put &t;
