topic Re: proc sql ERROR: No data found/modified in SAS Programming

proc sql ERROR: No data found/modified

havmaage — Mon, 26 Oct 2020 13:56:45 GMT

Hi Sas,

when running delete from table thought SQL Passthrough on mssql from OPC batch it errors out

with ERROR: No data found/modified.

CONNECT TO ODBC AS PASSTHRU
(noprompt="DRIVER={SQL SERVER};DATABASE=&_DB;Trusted_Connection=Yes;SERVER=&_INC;ansiNPW=yes;ansi_null=YES;autotranslate=yes");

    &SQLINI from connection to passThru (
	DELETE FROM SQL.TESTTABLE
	
 );

DISCONNECT FROM passThru;

i have notice that it has been mensioned in the past and there should be a hotfix

https://support.sas.com/kb/42/537.html

But as for now this is not an option. Does anybody know of any workound to avoid this.

Re: proc sql ERROR: No data found/modified

ChrisNZ — Mon, 26 Oct 2020 22:07:53 GMT

1. What's variable SQLINI ? You need an execute by statement here, not a select ... from statement.

Re: proc sql ERROR: No data found/modified

havmaage — Tue, 27 Oct 2020 09:05:36 GMT

Oh sorry &SQLINI has a text string value (select * from )

Re: proc sql ERROR: No data found/modified

ChrisNZ — Tue, 27 Oct 2020 09:10:06 GMT

As I said that's incorrect.