topic Re: Updating sas table with multiple updates from different users in SAS Procedures

Updating sas table with multiple updates from different users

jerry898969 — Mon, 16 Sep 2013 13:57:39 GMT

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

Re: Updating sas table with multiple updates from different users

Haikuo — Mon, 16 Sep 2013 14:34:14 GMT

Do you have SAS/SHARE?

Re: Updating sas table with multiple updates from different users

jerry898969 — Mon, 16 Sep 2013 14:58:02 GMT

Hi Hai,

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

Thank you

Re: Updating sas table with multiple updates from different users

LinusH — Mon, 16 Sep 2013 18:20:05 GMT

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

Re: Updating sas table with multiple updates from different users

SASKiwi — Mon, 16 Sep 2013 19:44:14 GMT

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

Re: Updating sas table with multiple updates from different users

jerry898969 — Thu, 24 Oct 2013 16:34:39 GMT

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

Re: Updating sas table with multiple updates from different users

SASKiwi — Thu, 24 Oct 2013 18:57:21 GMT

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.

Re: Updating sas table with multiple updates from different users

Patrick — Fri, 25 Oct 2013 09:17:27 GMT

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....