BookmarkSubscribeRSS Feed
Obsidian | Level 7

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



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


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.



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?
Calcite | Level 5

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

Lapis Lazuli | Level 10 fja
Lapis Lazuli | Level 10
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.
Calcite | Level 5

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

Lapis Lazuli | Level 10 fja
Lapis Lazuli | Level 10
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.
Super User

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

Calcite | Level 5

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 time I'll even check the date before I have the license to express myself


Lapis Lazuli | Level 10 fja
Lapis Lazuli | Level 10
Ah ... I did not pay attention to the date of the original post. 🙂 --fja


Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 5 in conversation