Using the LIBNAME access engine to assign a libref to a MS Access
database, there are two options that will help assign an accurate length
to the longer MS Access memo fields.

  1.  SCAN_TEXT = YES to tell SAS to scan the length of text data and
      use the length of the longest string data found as the SAS
      variable width.

  2.  DBMAX_TEXT = integer to specify the maximum length of the SAS
      character variable.

Using SCAN_TEXT=YES, the length of the variable will be set exactly
as long as it needs to be to accommodate the longest length found in
the data.

Using DBMAX_TEXT=nnnn by itself sets or forces a fixed length value.
For example:

  libname mylib 'c:\my documents\mydb.mdb' dbmax_text=2056
         scan_text=yes;

Operating System and Release Information