1. If you have not used this transformation in DI studio you will not know the answer.
2. The question? Does Data Validation generate an error table or does one(error table) have to be created first. Under options it asks for libname.Tablename to send errors but it does not say if it will create a table or you must create a table.
Also we need a community for DI STudio.
Wow I just realized the version this company is using is from 2009 4.2. So I really don't expect anyone to be able to answer.
Based on newer DIS versions but from memory it's the same for DIS4.2:
You can under one of the tabs choose if an Error and/or Exception table should get created. You then have a list of standard columns but you can modify this selection.
I believe the default location for the Error and Exception tables are WORK and you then might also want to register the tables and point them to a permanent location.
So yes, SAS/DIS does it for you but you must tell DIS how it should be doing it.
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.