You got the error because you may not have the sqlsrv engine. It can be verified in PROC SETINIT.
Try the ODBC or OLEDB engine instead.

Just my thought.
(1) the length of a SAS character variable is limited up to 32767, so your SQL text might have been truncated.
(2) you may create a SQL Server view with the code variable separated into two pieces, then let SAS read the view. If you're not allowed to create views in the database, create a temporary table sort of thing would be fine.

I only get 1000 character far away from 32767
Do you know what happen?

no idea! haven't used SQL Server since I went down hell.
Maybe it's because SAS cannot determine the actual length of a SQL TEXT or VARCHAR(MAX) field, then it decides by itself to keep the first 1000 characters?
http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#n1aqglg4ftdj04n1eyvh2l3367ql.htm
Check the link above, the default value for DBMAX_TEXT is 1024. How the hell you got 1,000?!

Anyway, I think you may break your SQL TEXT field into either 8 VARCHAR(7500) fields or 2 VARCHAR(MAX) fields. In the latter case, set option DBMAX_TEXT to 32767 as well. Then SAS should be able to handle that.

thank for helping
My fault.the accurate number is 1024
But the DBMAX_TEXT is only supported in the libname statement
As soon as I run the code as follow ,it turn out the errors.The error is:what does it mean? I haven't install the SQLSVR engine?But I do run the code using the "SQL PASS:proc sql" successfully !
Can you give me some advice?