Hi ,
does anyone know how i can stop a flow in sas di when i have an error in a transformation ?
Thanks
CL
When you say DI, you mean when you are actually running inte DI Studio GUI?
When executing om the WorksSpace server, there is no interaction between DIS and the server session, DIS is responsible for generating the current SAS code based on metadata, and then submit that code to the server.
So no, DIS itself cannot stop after an error.
What you can play with are global SAS options that handle how the SAS session should respond to error events. I think the default is that after a syntax error, SAS will set obs=0, and then just syntax check the rest of the code.
Question is, why do you want to stop execution when working in DIS? I can't say that I ever had that need.
Hi,
Return code check transformation could do something for you specially when setting the action with error but not specially to stop DIS if error occurs.
why are you looking for it ?
Regards
Uma Shanker Saini
This topic and chapter from the user guide might help (Perform Actions Based on the Status of a Transformation): SAS(R) Data Integration Studio 4.8: User's Guide
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.