Date:         Tue, 19 Aug 1997 20:29:33 -0400
Reply-To:     Anthony Ayiomamitis <ayiomamitis@IBM.NET>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Anthony Ayiomamitis <ayiomamitis@IBM.NET>
Subject:      Re: Column lengths in SQL
Content-Type: text/plain; charset=us-ascii

Anthony Ayiomamitis wrote:
>
>
>      I do not think that this is an SQL limitation as I tried a small
> example with a PROC SQL step and was able to generate and store a string
> that happened to be 150 bytes in length.
>
 
   ... the maximum length string I can generate directly within a PROC
SQL step is 200 bytes. Can someone with or without an SAS/SQL manual
please confirm or deny?
 
   The strange thing is that I purposely did not create a table to hold
this string but had the string go directly into a macro (using INTO
:MACROVAR) which recent discussion has documented bytes in the tens of
thousands.
 
Anthony.