We could see the result dataset upto SQL joins in a job. But the next transformation table loader is not working. It is not throwing any errors or warnings as well. Executions seems to be successful. But we could not find the records in the target dataset. Same issue exists across several jobs.
Kindly suggest ideas of where to check to solve this issue.
What update method do you use?
What DBMS do you use for the target tables?
If there something about the logic in the table loader, this could normally be found in the log (e.g. no of records in the different work tables used in table loader).
If you load to an external RDBMS, using SAS/ACCESS debugging will help you see the RDBMS specific SQL syntax for the update:
options SASTRACE=',,,d' SASTRACELOC=SASLOG;
I guess there would be mapping issue.Just check if your source column and target column are mapped correctly in Mapping tab in table loader transformation.
If the source col and target col are not same then you need to do manually mapping each source to target variable(automatic mapping will not work if column names are different).
As suggested by Linus you an check the log for more information.
Thanks,
Shiva
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.