I have the following macro definition and be stuck in middle %let From_Date = JAN07; %let new_input=%sysfunc(inputn("JAN07"d, MONYY5.)); %let new_input=%sysfunc(inputn(&From_Date., MONYY5.)); %put &new_input.; data test; do k=0 to 10; y= %sysfunc(intnx(month, &new_input., k , 'e')); output; end; run; 1. the second clause can not read in 'JAN07"d', the 3th clause can output correctly, why this happen. 2. in loop, k can not be recognized by intnx function as a number, the error is "Argument 3 to function INTNX referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number." Thanks,
... View more