Hi, i have a problem in this code... the "IF" statement dont work... someone can help me? The Macro Variable G_STATUS is created in this Macro %macro CONSULTAR_TABELA(RELATORIO,BASE); %GLOBAL G_STATUS; %LOCAL STATUS; proc sql; SELECT T1.status INTO: STATUS FROM CONTROLE.BASE_VALIDADOR T1 WHERE COMPRESS(RELATORIO) EQ &RELATORIO. AND COMPRESS(TABELA) EQ &BASE. ; RUN; %LET G_STATUS = &STATUS; %mend CONSULTAR_TABELA; and i would like to use this macro variable in this "IF" conditional: data _NULL_; %let RELATORIO = 'SOL'; %let TABELA = 'ZCRM_O02'; %CONSULTAR_TABELA(&RELATORIO,&TABELA); %IF &g_status ="EM ATUALIZACAO" %then x=1; run; The error is: 61 %IF &g_status ="EM ATUALIZACAO" %then ERROR: The %IF statement is not valid in open code. 62 x=1; 63 run; thanks for all
... View more