Date:         Fri, 12 Nov 2004 21:44:41 +0100
Reply-To:     Victor Schneider <vbschneider@YAHOO.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Victor Schneider <vbschneider@YAHOO.DE>
Subject:      Problem with varchar in proc sql
Content-Type: text/plain; charset=us-ascii

Hi,

I have a problem with proc sql. I want to make a copy of an oracle
database with the statement

proc sql;
create table test as select * from mydb.test;
quit;

My problem is, that I have a varchar field with 32768 in the oracle
database. SAS imports only the first 1024 byte of this field. What
must I do, to tell SAS make a complete copy of the 32kb varchar field?

Thanks a lot
Victor