topic Re: Data lengths from a mysql connection in SAS Programming

Data lengths from a mysql connection

deleted_user — Wed, 15 Oct 2008 09:38:15 GMT

Hi

I connect to a mysql database and all my maximum data length is 1024.
can i increase this somehow?
im under the impression that sas can handle 32,000.
i connect using the normal libname statement.

thanks

Spud

Re: Data lengths from a mysql connection

LinusH — Wed, 15 Oct 2008 10:40:16 GMT

You are probably trying to read a column of the text or blob types in MySQL. In SAS, use the DBMAX_TEXT= option to set the number of chars that you wish see in SAS. The default value is 1024. See:

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a002914076.htm

and

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a001371562.htm

/Linus

Re: Data lengths from a mysql connection

deleted_user — Fri, 17 Oct 2008 13:16:21 GMT

Thats fantastic....cheers