SAS DI SCD 2 NOT WORKING IN A PROPER WAY

[Reem97]

SCD2 table have more than one current record  row (change current indicator) with flag "Y" per business key which is an odd behaviour looking for the root cause, any help please.

[Patrick]

Duplicate business keys in your source table could potentially cause such a situation. To really know you would have to investigate the DIS generated code.

[LinusH]

Also, analyze your source and target data.

Take you code and change the debug flag, which will keep the work table from being deleted, and then execute the code in an interactive SAS session, like EG.