sql transactions in sas

[esbabu]

I am new to SAS.
Wondering if Sas proc sql supports Sql type transactions

[LinusH · Accepted solution]

PROC SQL is SAS implementation of the query language.

And yes, SAS itself does not support transactions.

If your data is stored in a RDBMS PROC SQL can make use of som transactional behaviour in the database.

Transactions is mainly useful in OLTP scenarios.

What is your requirement/use case regarding this

[esbabu]

Thanks @LinusH 
I was actually trying to explore using transaction to commit changes to a table.
By transactions I mean either all or none are committed or written to the table.
Thanks for answering my question.

[Tom]

---

@esbabu wrote:

Thanks @LinusH 
I was actually trying to explore using transaction to commit changes to a table.
By transactions I mean either all or none are committed or written to the table.
Thanks for answering my question.

---

A normal data step meets your definition of transactions, the output dataset is only replaced when the data step complete without errors.

For example you might want to use the UPDATE statement to apply transactions to an existing dataset.  Note that it does not work in the new CAS environment, only the traditional SAS data step.

[Ksharp]

You could check Constraint Condition:
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n00ms57pqqsmecn1va63jpmlq83t.htm

https://documentation.sas.com/api/collections/sasadmincdc/v_046/docsets/calaudit/content/calaudit.pd...