ERRO IN SAS CODE

[EloarL]

When generating a code in sas guide, code specified below generates the error. How do I demote this table?

code:

%let tabela = BS_VENDAS_DIGITAIS_MONITOR; /*nomedatabela*/
%let biblioteca = TLVVA; /*biblioteca de origem*/
%let pastaDestino = /Canais Indiretos/Tabelas em Memória;
%include '/sistemas/shell/load_table_users_canaisindiretos.sas';

ERROR: The target table BS_VENDAS_DIGITAIS_MONITOR of the promotion already exists. Please specify a different name.
ERROR: The action stopped due to errors.

[JosvanderVelden]

With the supplied information it is difficult to indicate what could be causes. Do you drop the table in the sas program when it already exists? Are you the only user with access? Do you try to run this several times in a row?

[Teo_ita]

Following a server restart it happened to me that Viya has regenerated a similar one. Check in the Environment Manager that there is no table with similar name (in your case, for example: _BS_VENDAS_DIGITAIS_MONITOR_938H48F43T234.....):

and delete it.
Then try to regenerate it.
It worked for me
Hello!

[fja]

Hello!
Hard to tell, as Jos has already put it. If you just run the %include line does the reproduce the error?
Otherwise you needed to narrow the error a bit and post code and log here.
--FJa

[Teo_ita]

I'm not sure exactly what you mean...
I just brought my experience on this error, that's all

I just thought it was useful...

[fja]

Hello teo_ita!
My reply was not addressed to you but to the original poster EloarL. Hence, probably, the misunderstanding 🙂
Thank you very much for sharing your thoughts and experience, Teo_ita.
--fja

[ballardw]

@fja @Teo_ita 

The original poster of this question has not returned, or at least not posted anything, since Oct 2019. So seems unlikely that responses to the original question are needed or used.

Resurrecting older posts, especially if years old, is usually not needed.

[Teo_ita]

If you say so… thanks for the enlightenment
but I believe in resurrection!
This problem happened to me fresh fresh 2 days ago
Anyway, ok, I give up...next time I'll even check the date before I have the license to express myself

bye

[fja]

Ah ... I did not pay attention to the date of the original post. 🙂 --fja