Help using Base SAS procedures

A problem with integrity constraint

Reply
N/A
Posts: 0

A problem with integrity constraint

Hi guys,

I have encounter a problem in SAS data integration studio 3.4.

The problem is like this. After a transformation, all the data will output into an temp target table. Then I load this data using the table loader into the target table

Before I loaded into the target table, the temp target table has 80000 records.

After I loaded into the target table, the target table has 70000 records.

It is due to:

WARNING: Add/Update failed for data set STG_SEAB.PERSONAL because data value(s) do not comply with integrity constraint _NM0001_.
(Occurred 498 times.)

WARNING: Add/Update failed for data set STG_SEAB.PERSONAL because data value(s) do not comply with integrity constraint _NM0002_.
(Occurred 9312 times.)

So how to solve this problem?

Thanks.

Yours Sincerely,
helphelp
Super Contributor
Posts: 319

Re: A problem with integrity constraint

Hi,

Try to check the columns of your target table. probably some of your columns should not contain a null value and then you try to insert records with a null value on that particular column. Hope this helps.

regards,
milton
Ask a Question
Discussion stats
  • 1 reply
  • 1659 views
  • 0 likes
  • 2 in conversation