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.
Need further help from the community? Please ask a new question.