Date:         Thu, 10 Oct 1996 11:04:45 -0500
Reply-To:     "Dale Q. Marmaduke" <dmarmad@INDYUNIX.IUPUI.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Dale Q. Marmaduke" <dmarmad@INDYUNIX.IUPUI.EDU>
Subject:      sybase data fields too long for access

My Sybase database has a field which is 255 long.
Using proc access to create an access descriptor and
access view, I can't reduce the length.
 
I can print the data, with truncated results.  This
is acceptable.  (proc print data=vlib.project;)  I
can't use the table as a sas dataset.  data project; set vlib.project;
and I can't do a proc contents data=vlib.project;
because of the error.....field cannot have a length of 255.
 
Does anyone know how to reduce the lenght so I can
move forward.
 
Dale Marmaduke
Indiana University Purdue University at Indianapolis
wishing he or sas were smarter
dmarmad@iupui.edu