DI Studio question. I want to make sure that if an input table is empty, the job fails (triggers an ERROR) and stops running. How can this be accomplished?
P.S. Should be resolved without user written code.
Thanks for your time.
SAS Data Integration Studio can be extended with your own user written transformations, so you would need to code it once and then just use it again and again. The code for such a transformation could look like this:
If you want full control then I believe you would have to implement this either as pre-code in the node or as a custom transformation.
You could create a autocall macro for this and then simply call this autocall macro. Some nodes generate a macro "%etls_recordCheck" which could serve as a starting point to write such a macro.
SAS Data Integration Studio can be extended with your own user written transformations, so you would need to code it once and then just use it again and again. The code for such a transformation could look like this:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.