Help using Base SAS procedures

Updating sas table with multiple updates from different users

Reply
Super Contributor
Posts: 398

Updating sas table with multiple updates from different users

Hello everyone,

I'm about to start a project that is a windows forms front end with c# in the code behind and sas as the back end.   My question is if i'm using oledb can multiple users do an update, insert or delete on the same table at the same time?

Thank you

Respected Advisor
Posts: 3,124

Re: Updating sas table with multiple updates from different users

Do you have SAS/SHARE?

Super Contributor
Posts: 398

Re: Updating sas table with multiple updates from different users

Hi Hai,


Thank you for your reply.  Yes we are using a SAS/SHARE.

Thank you

Super User
Posts: 5,255

Re: Updating sas table with multiple updates from different users

I sugest that you resd the SHARE documentation.  It will allow concurrent reads and updates,  but not entirely the same way as a RDBMS.

Data never sleeps
Super User
Posts: 3,101

Re: Updating sas table with multiple updates from different users

If you are using SAS/SHARE with SAS datasets then OLEDB would not be necessary.

Super Contributor
Posts: 398

Re: Updating sas table with multiple updates from different users

Hi LinusH,

Sorry for my delayed response but I ready the SHARE documentation and I didn't fully understand it.  Do I need to handle the row locks myself?

I looked at Chapter 5 Locking SAS Data Objects and I understand the locking portion.  I want to make sure that is the correct way to go about doing it.

Thank you again for any help

Super User
Posts: 3,101

Re: Updating sas table with multiple updates from different users

The way I read it SAS/SHARE provides a default set of rules for locking SAS data depending on how you are accessing it. However you can override these rules by applying locks explicity with the LOCK statement/command. However that's just my take on the doc, not having used SHARE myself. Best to get other opinions from those who actually use it.

Respected Advisor
Posts: 3,887

Re: Updating sas table with multiple updates from different users

I've used SAS/Share in the past. You can select if you want a table lock or a row level lock. I would assume you normally would want row level locking.

Yes, you can have several processes with write access on row level. That's what SAS/Share is for.

Be aware that SAS/Share is single threaded so there could be some performance issues if you're having lots of users accessing at the same time. I try normally to use a DBMS if I need concurrent write access (or read/write at the same time).

I strongly prefer using SAS/Share for small tables only like control tables and the like - but we don't have always the luxury of choice....

Ask a Question
Discussion stats
  • 7 replies
  • 313 views
  • 0 likes
  • 5 in conversation