topic Re: ERRO IN SAS CODE in SAS Programming

ERRO IN SAS CODE

EloarL — Fri, 18 Oct 2019 14:25:56 GMT

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.

Re: ERRO IN SAS CODE

JosvanderVelden — Fri, 18 Oct 2019 17:30:21 GMT

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?

Re: ERRO IN SAS CODE

Teo_ita — Fri, 20 Jan 2023 08:43:07 GMT

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!

Re: ERRO IN SAS CODE

fja — Fri, 20 Jan 2023 08:53:36 GMT

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

Re: ERRO IN SAS CODE

Teo_ita — Fri, 20 Jan 2023 09:03:22 GMT

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...

Re: ERRO IN SAS CODE

fja — Fri, 20 Jan 2023 13:01:18 GMT

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

Re: ERRO IN SAS CODE

ballardw — Fri, 20 Jan 2023 15:52:53 GMT

@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.

Re: ERRO IN SAS CODE

Teo_ita — Fri, 20 Jan 2023 16:50:10 GMT

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

Re: ERRO IN SAS CODE

fja — Fri, 20 Jan 2023 20:30:37 GMT

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