The SAS Output Delivery System and reporting techniques

Is there a max length for a Proc SQL statement?

Reply
N/A
Posts: 0

Is there a max length for a Proc SQL statement?

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
SAS Employee
Posts: 174

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

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
N/A
Posts: 0

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

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

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

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

-- David Kelley, SAS
Ask a Question
Discussion stats
  • 3 replies
  • 142 views
  • 0 likes
  • 2 in conversation