I'm trying appling this macro: %MACRO EXPOSICOES(TABELA,VL_PMT,EXPOSICAO,VAR_PROVISAO,CONDICAO); PROC SQL; CREATE TABLE SALDO_&TABELA. AS SELECT CPFCNPJ, %IF &TABELA NOT IN (OUTROS,AGRO,CHEQUE) %THEN %DO; SUM(&VL_PMT.) AS PMT_&TABELA., %END; MAX(DIAS_ATRASO) AS DIAS_ATRASO_&TABELA., FROM TABELA WHERE CPFCNPJ > 0 GROUP BY CPFCNPJ ;QUIT; %MEND EXPOSICOES; %EXPOSICOES(OUTROS,.,TABELA,VAR_PROVISAO) however i always get this message error: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &TABELA NOT IN (OUTROS,AGRO,CHEQUE) ERROR: The macro EXPOSICOES will stop executing. anyone could help me? 😞
... View more