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.
08-15-2017 01:41 PM
I have similar problem. I need to update file, while in memory, but every time I try to modify file with data step I receive message that I have no UPDATE rights.
I can create and delete files, but I can't modify them.
Simple delete rows would be enough, because I am able to append, but somehow LASR does not allow me to do it.
Could you advise if you had similar problem or how you resolve your problem?
Thank you in advance
Need further help from the community? Please ask a new question.