开发者

Large character field sizes in SAS

开发者 https://www.devze.com 2022-12-27 13:06 出处:网络
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

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 SA开发者_如何学GoS? Any suggestions other than the obvious one of breaking it down into smaller substrings?

Thanks Rob


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消