I have the following Macro code: %macro LTV_DSCR(file1,file2,var,bins,lm1,lm2,rounding); %local i j part1 part2; %let i=1; %do %while(%scan(%str(&file1), &i) ne); %let part1=%scan(%str(%&file1), &i); %let j=1; %do %while(%scan(%str(%&file2), &j) ne); %let part2=%scan(%str(%&file2), &j); .......... %let j=%eval(&j+1); %end; %let i=%eval(&i+1); %end; %mend LTV_DSCR; %LTVDSCR(RT OR OF IN MF LO, W SE SW MW NE, LTV, 10, 2.5, 4, 0.1); The code gives error message: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: %scan(&file1, &i) ne ERROR: The condition in the %DO %WHILE loop, %scan(&file1, &i) ne, yielded an invalid or missing value, . The macro will stop executing. ERROR: The macro LTV_DSCR will stop executing. This only happens when it reaches word like "OR" "NA". How should I modify my code?
... View more