topic CLOB in SAS Programming https://communities.sas.com/t5/SAS-Programming/CLOB/m-p/118996#M259560 <HTML><HEAD></HEAD><BODY><P>I have never heard the term clob before yesterday so I am very new to the subject.&nbsp; If something is stored in clob will it be as easy as using an import wizard to pull it into SAS?&nbsp; Does anyone know of any good documentation on the topic?</P><P></P><P>Thanks,</P><P></P><P>Mark</P></BODY></HTML> Wed, 24 Apr 2013 15:49:14 GMT Steelers_In_DC 2013-04-24T15:49:14Z CLOB https://communities.sas.com/t5/SAS-Programming/CLOB/m-p/118996#M259560 <HTML><HEAD></HEAD><BODY><P>I have never heard the term clob before yesterday so I am very new to the subject.&nbsp; If something is stored in clob will it be as easy as using an import wizard to pull it into SAS?&nbsp; Does anyone know of any good documentation on the topic?</P><P></P><P>Thanks,</P><P></P><P>Mark</P></BODY></HTML> Wed, 24 Apr 2013 15:49:14 GMT https://communities.sas.com/t5/SAS-Programming/CLOB/m-p/118996#M259560 Steelers_In_DC 2013-04-24T15:49:14Z Re: CLOB https://communities.sas.com/t5/SAS-Programming/CLOB/m-p/118997#M259561 <HTML><HEAD></HEAD><BODY><P>CLOB is as you might know "character large object", a data type in Oracle (and others?).</P><P>Since SAS has limited to 32K for char variables, the information in your CLOBs might be truncated when accessing these using the SAS/ACCESS libname engine for your RDBMS.</P><P>A work around is to use explicit SQL pass-thru to access the data. If you need it in SAS, try to split the CLOB into smaller chunks, before accessing/importing it to SAS.</P><P><A href="http://support.sas.com/kb/41/575.html" title="http://support.sas.com/kb/41/575.html">41575 - SAS/ACCESS® Interface to Oracle supports BLOB and CLOB data types with a character limit of 32767</A></P></BODY></HTML> Wed, 24 Apr 2013 18:28:31 GMT https://communities.sas.com/t5/SAS-Programming/CLOB/m-p/118997#M259561 LinusH 2013-04-24T18:28:31Z