Thank you for the replies on this. I think this approach should end up working for me. I had to put in a replace clause in the statement that saves the table to a physical copy for when the data is refreshed. I am getting a similar error "The target table newtable of the promotion already exists. Please specify a different name." on the statement proc casutil; promote casdata='newtable' incaslib='casuser'; quit; I see that this statement does not also have a replace clause and recommends dropping then doing a new promote. I'm not clear on how to do this, I've run into errors like "There is no session-scope table newtable in caslib" or once that reads the same as above. What would be a way to modify the program to adjust for replacing when data is refreshed?
... View more
