No of inserts in a db

[justusjillella]

How to fund no of rows inserted into a database In a single insert when updating the db

[PeterClemmensen]

Show us your code?

[Kurt_Bremser]

Use &sqlobs:

data have;
x1 = 'A';
x2 = 1;
stop;
run;

proc sql;
insert into have
values ('X',2)
values ('C',3)
;
quit;

%put &sqlobs;

Log excerpt:

50         %put &sqlobs;
2

[justusjillella]

Hi, thanks for the reply
We are inserting data into a table in Google cloud using explicit method. We would like to know in one insert how many rows are inserted into the table.
Is there any option to see it in log

[andreas_lds]

---

@justusjillella wrote:
Hi, thanks for the reply
We are inserting data into a table in Google cloud using explicit method. We would like to know in one insert how many rows are inserted into the table.
Is there any option to see it in log

---

Have you tried the code posted by @Kurt_Bremser ?

[Kurt_Bremser]

My code will most probably not work, as with explicit passthrough the whole work is done in the DBMS, and SAS SQL only sees EXECUTE() with some text inside. Personally, I have no experience with explicit PT.

It might be possible to structure the PT code in a way that it renders the number as output, and then use that as "from" in the SAS SQL code.