Question: I checked, and all the table involved are not promoted So the discussed code: proc cas;
tableList={"topic_scoring_v1",
"mkt_topicmodel_svdu",
"mkt_topicmodel_topics",
"mkt_topicmodel_docpro",
"mkt_topicmodel_config",
"mkt_topicmodel_terms"
};
do thisTable over tableList;
table.promote /
caslib="Global Marketing (DNFS)"
,name=thisTable
/* DROP=TRUE gets rid of the session table creating the globla table */
,drop=TRUE,
targetLib="Global Marketing (DNFS)" ;
end;
run; Should promote the tables and drop the session versions. However, I get the following : 80 proc cas;
81
82 tableList={"topic_scoring_v1",
83 "mkt_topicmodel_svdu",
84 "mkt_topicmodel_topics",
85 "mkt_topicmodel_docpro",
86 "mkt_topicmodel_config",
87 "mkt_topicmodel_terms"
88 };
89
90 do thisTable over tableList;
91 table.promote /
92 caslib="Global Marketing (DNFS)"
93 ,name=thisTable
94 /* DROP=TRUE gets rid of the session table creating the globla table */
95 ,drop=TRUE,
96 targetLib="Global Marketing (DNFS)";
97 end;
98 run;
NOTE: Active Session now CASAUTO.
ERROR: The target table topic_scoring_v1 of the promotion already exists. Please specify a different name.
ERROR: La acción se ha detenido debido a los errores.
ERROR: The target table mkt_topicmodel_svdu of the promotion already exists. Please specify a different name.
ERROR: La acción se ha detenido debido a los errores.
ERROR: The target table mkt_topicmodel_topics of the promotion already exists. Please specify a different name.
ERROR: La acción se ha detenido debido a los errores.
ERROR: The target table mkt_topicmodel_docpro of the promotion already exists. Please specify a different name.
ERROR: La acción se ha detenido debido a los errores.
ERROR: The target table mkt_topicmodel_config of the promotion already exists. Please specify a different name.
ERROR: La acción se ha detenido debido a los errores.
ERROR: The target table mkt_topicmodel_terms of the promotion already exists. Please specify a different name.
ERROR: La acción se ha detenido debido a los errores. Should have the "Drop" option allowed to promote the tables and at the same time drop the session versions? Why I'm getting the error then?
... View more