Hi everyone,
How to performer a begin/commit/rollback operation for two or more steps in proc sql?
For example:
proc sql;
connect to oracle as ora(...);
**begin transaction
insert into ora.a;
insert into ora.b;
delete from ora.c;
**commit transaction for success
or
**rollback transaction for fail
quit;
Thanks,
...
Hi, LinusH
Thanks for your attention!
I have a linked_people (id_people1, id_people2) table and a history_people (id_people, operation_date) table. Everytime when insert a row in people_linked table, have be inserted two rows in history_people table.
This operation need be atomic.
Just wrap the code you would use in Oracle PL-SQL, including COMMIT and ROLLBACK commands, in an EXECUTE statement:
proc sql;connect to oracle as ora(...);
execute(
**begin transaction
insert into ora.a;
insert into ora.b;
delete from ora.c;
**commit transaction for success
or
**rollback transaction for fail
) by ora;
quit;
Hi SASKiwi,
Thanks for response!
But, the problem is source table is a sas dataset.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.