CODEWITHSUNDEEP
mysqlodbctypesblobsas
Robert Penridge
Robert Penridge

Reputation: 8513

Large character field sizes in SAS

I am trying to import a large blob field from a MySQL table via SAS ODBC passthrough. The field is larger than the maximum length allowed in SAS. According to SAS 9.2 documentation character type fields can have a maximum length of 32k. Has anyone had experience storing large character fields in SAS? Any suggestions other than the obvious one of breaking it down into smaller substrings?

Thanks Rob

Upvotes: 2

Views: 622

Answers (1)

Jay Stevens
Jay Stevens

Reputation: 5913

If you REALLY do need all 32K of that data to operate on, I would import it into more than one column and use arrays to iterate over those columns any time you need to do processing.

See RunSubmit.com for more info.

Upvotes: 2

Related Questions