topic Re: Is there a max length for a Proc SQL statement? in ODS and Base Reporting

Is there a max length for a Proc SQL statement?

deleted_user — Fri, 05 May 2006 18:26:47 GMT

Looks like my SQL where clause is being truncated which causes an error when I run it in SAS. The syntax is correct when checked. Was wondering if there is a max length for the where clause of the proc SQL statement? If so, do you know what it is?
Message was edited by: Suitland at May 5, 2006 2:42 PM

Re: Is there a max length for a Proc SQL statement?

David_SAS — Fri, 05 May 2006 23:22:23 GMT

Our SQL expert says:

From what I can remember there isn't a max length that PROC SQL sets. However, the forum question didn't say what context that the WHERE clause was being used in. That could make a difference, especially with some of the SAS/ACCESS engines. These engines can actually have varying amounts of space set aside for predicates.

-- David Kelley, SAS

Re: Is there a max length for a Proc SQL statement?

deleted_user — Mon, 08 May 2006 15:44:06 GMT

Hi, my WHERE clause consists of a great number of comparison (><,eq) statements, and joining them by AND/OR, and is nested extensively.

Re: Is there a max length for a Proc SQL statement?

David_SAS — Mon, 08 May 2006 18:36:09 GMT

I recommend that you report your problem to Technical Support. See http://support.sas.com/techsup/intro.html .

-- David Kelley, SAS