03-21-2017 06:53 AM
I have loaded data from a file in LASR server. Take the example data set as below:
|WRDATE||EMPREF||Home Cost Ctr||Home Department||TAS Cost Centre||TAS Project||TAS Task|
|27-02-2017||9||SALV ADMIN||Salvage Bay 7||SALV ADMIN||TEAM LEADER|
|28-02-2017||9||SALV ADMIN||Salvage Bay 7||SALV ADMIN||TEAM LEADER|
|27-02-2017||16||CGL||CGL WH Bay 4||TOM TOM||SCANNER|
|28-02-2017||16||CGL||CGL WH Bay 4||TOM TOM||SCANNER|
Now, I am receiving a file with modified data and I need to update the existing record. Could you please suggest how this can be achieved ? One of the ways is to use Proc Imstat. I created a column "flag" in existing dataset. The new data was laoded in a dataset with flag set as 1. The flag for existing data set was set as 0. Through Proc Imstat, new data was appended to old. And then I deleted data where flag = 0. However, this would work only if I receive full file always. In my case, i am receiving ONLY modified data in new file. I was looking for a way to update the existing record with new record based on some key parameters. In this case Date, cost centre and Task are my keys.