Show us your code?
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 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 ?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.