topic Re: sql transactions in sas in SAS Programming

sql transactions in sas

esbabu — Tue, 04 Mar 2025 11:22:20 GMT

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

Re: sql transactions in sas

LinusH — Tue, 04 Mar 2025 14:02:46 GMT

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

Re: sql transactions in sas

esbabu — Tue, 04 Mar 2025 15:48:50 GMT

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.

Re: sql transactions in sas

Tom — Tue, 04 Mar 2025 19:34:46 GMT

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

Re: sql transactions in sas

Ksharp — Wed, 05 Mar 2025 01:06:12 GMT

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.pdf?locale=en