SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to Stop Data Integration Job when there are missing observations in data

Reply
New User
Posts: 1

How to Stop Data Integration Job when there are missing observations in data

 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.

 

 

 

Super User
Posts: 5,424

Re: How to Stop Data Integration Job when there are missing observations in data

Posted in reply to Alexaparte

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).

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 649 views
  • 0 likes
  • 2 in conversation