Select only updated records and load the updated records in SQL table

[David_Billa]

Will it works if the new data is inserted or if any existing data is deleted?

[ChrisNZ]

I don't understand the question. As you can see this answers the need you expressed.Adapt the code to your exact data.

[David_Billa]

If my trans data is as below then the MASTER dataset is not updating as we want. I tried to tweak your code but it didn't helped either.

data TRANS;
input (Id  Name  Sales   Transaction   Example  Act_Ind   Valid_From  Valid_To) (:$20.);
cards;
4   Track   False  10  121216  Y   20200404T000000   99991231T235959
run;

[ChrisNZ]

Did you read the document I pointed to?
To insert new records, you need to test for   _DSENOM   and   output   the new record.