I'm trying to run a macro during a connection or with teradata using SAS and when I run the code I'm getting the error. What can be the reason? Error in teradata?
/*====================== CODE ===========================*/
proc sql noprint;
connect to teradata (user=&Login. password=&Senha. server=tdpvivo schema=p_viedb);
%MonitorDePassos(3,'INÍCIO DA IMPORTAÇÃO DOS DADOS DO DW',0);
create volatile table LINHAS_PARQUE_CRT, no log as
primary index (ID_LNHA)
on commit preserve rows
execute (commit) by teradata;
/* %MonitorDePassos(3,'FIM DA IMPORTAÇÃO DOS DADOS DO DW',0);*/
/* DESCONECTANDO DO TERADATA*/
disconnect from teradata;
/*================ error ============= */
WARNING: Apparent invocation of macro MONITORDEPASSOS not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.