BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
avinashaecwb
Obsidian | Level 7

Hi

 

I have loaded data from a file in LASR server. Take the example data set as below:

 

WRDATEEMPREFHome Cost CtrHome DepartmentTAS Cost CentreTAS ProjectTAS Task
27-02-20179SALV ADMINSalvage Bay 7SALV ADMINTEAM LEADER
28-02-20179SALV ADMINSalvage Bay 7SALV ADMINTEAM LEADER
27-02-201716CGLCGL WH Bay 4TOM TOMSCANNER
28-02-201716CGLCGL WH Bay 4TOM TOMSCANNER

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
avinashaecwb
Obsidian | Level 7

 Was able to achieve this using Update statement in Data Step.

View solution in original post

2 REPLIES 2
avinashaecwb
Obsidian | Level 7

 Was able to achieve this using Update statement in Data Step.

jakubniescior
Fluorite | Level 6

Hi,

 

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 2000 views
  • 1 like
  • 2 in conversation