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
SAS Super FREQ

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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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