topic Re: No of inserts in a db in SAS Programming

No of inserts in a db

justusjillella — Thu, 10 Oct 2019 06:30:07 GMT

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

Re: No of inserts in a db

PeterClemmensen — Thu, 10 Oct 2019 06:37:24 GMT

Show us your code?

Re: No of inserts in a db

Kurt_Bremser — Thu, 10 Oct 2019 06:38:01 GMT

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

Re: No of inserts in a db

justusjillella — Thu, 10 Oct 2019 07:08:46 GMT

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

Re: No of inserts in a db

andreas_lds — Thu, 10 Oct 2019 08:37:33 GMT

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

Re: No of inserts in a db

Kurt_Bremser — Thu, 10 Oct 2019 08:57:50 GMT

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.