Error in running macro with teradata connection

General

Error in running macro with teradata connection

Greetings!



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 ===========================*/

RSUBMIT;

 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);

   execute

   (

    create volatile table LINHAS_PARQUE_CRT, no log as

    (

     select

      *

      from

      TABLE_TEMP

    )

    with data

    primary index (ID_LNHA)

    index (ID_PSSA)

    on commit preserve rows

   )by teradata;

   execute (commit) by teradata;

/*   %MonitorDePassos(3,'FIM DA IMPORTAÇÃO DOS DADOS DO DW',0);*/

  /* DESCONECTANDO DO TERADATA*/

  disconnect from teradata;

 quit;

ENDRSUBMIT;

/*================ 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.

Tks

Tags (4)
1 REPLY
Enthusiast

Re: Error in running macro with teradata connection

I don't think it is Teradata error. ERROR 180-322 is a SAS error.