https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896862#M20868 <P>Also, analyze your source and target data.</P> <P>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.</P> <P>&nbsp;</P> Tue, 03 Oct 2023 07:01:51 GMT LinusH 2023-10-03T07:01:51Z https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896765#M20866 <P><SPAN>SCD2 table have more than one current record&nbsp; row (change current indicator) with flag "Y" per business key which is an odd behaviour looking for the root cause, any help please.</SPAN></P> Mon, 02 Oct 2023 18:44:23 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896765#M20866 Reem97 2023-10-02T18:44:23Z https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896842#M20867 <P>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.</P> Tue, 03 Oct 2023 02:35:58 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896842#M20867 Patrick 2023-10-03T02:35:58Z https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896862#M20868 <P>Also, analyze your source and target data.</P> <P>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.</P> <P>&nbsp;</P> Tue, 03 Oct 2023 07:01:51 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-DI-SCD-2-NOT-WORKING-IN-A-PROPER-WAY/m-p/896862#M20868 LinusH 2023-10-03T07:01:51Z