topic Re: Link different output table producing steps in SAS Studio Flows in SAS Viya

Link different output table producing steps in SAS Studio Flows

acordes — Wed, 09 Oct 2024 15:17:50 GMT

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

Re: Link different output table producing steps in SAS Studio Flows

SASJedi — Wed, 09 Oct 2024 17:56:47 GMT

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?

Re: Link different output table producing steps in SAS Studio Flows

ballardw — Wed, 09 Oct 2024 20:16:20 GMT

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.