Hi,
I am quite new in SAS Data Integration Studio, Can somebody help me with a data integration studio job that I need to create that will stop whenever there are missing observations in a created dataset.
We will be having two external files. one for the actual data and one for the record count text file for record count comparison. I will attach some text files as sample for a file with a missing observation.
The job will also be creating a dataset with variables (job name, record count, actual record count, status/remarks) and a text file whenever the job was stopped or successful.
Thanks in advance for the answers.
Sounds like a job for a macro, which you can call from the Post step from the transformation where you want to have the check (and potential halt).
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.