BookmarkSubscribeRSS Feed
acordes
Rhodochrosite | Level 12

In the cstep4 I use sas code to create the castable temp1 in casuser. 

But if the table does not exist, that happens at first time execution, the flow runs with errors complaining just about this. To fix it, I have to run the code sequentially, the steps at the beginning end producing the table casuser.temp1. 

then the rest works as I run the right side of the flow. 

 

How can I do this smarter?

@MKQueen @SASJedi 

 

 

 

png2.png

 

 

png1.png

2 REPLIES 2
SASJedi
Ammonite | Level 13

From the code you show here, I'd expect a WARNING from PROC DELETE, but no errors. What error are you getting? Can you share the log of that first-time run when you are getting the error? 

Check out my Jedi SAS Tricks for SAS Users
ballardw
Super User

If you mean the data set that the macro variable &intab1 appears to reference the question may well be where is the macro variable Intab1 assigned a value? If the data set does not exist then the macro variable should not be assigned at all in my not so humble opinion but should terminate gracefully with an indication that step failed / the set wasn't there.

 

 

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

Discussion stats
  • 2 replies
  • 1013 views
  • 0 likes
  • 3 in conversation