https://communities.sas.com/t5/ODS-and-Base-Reporting/LOB/m-p/5837#M2358 I have an Oracle table which contains CLOB Data Type.<BR /> Is there any way i can take a value from CLOB into a SAS Variable and Parse or Scan words. <BR /> Is there any easy way to do this? and is there any restriction on the CLOB size to pull it.<BR /> I have SAS 9.1.2 and Access to Oracle.<BR /> Thanks Sat, 08 Dec 2007 14:31:26 GMT deleted_user 2007-12-08T14:31:26Z https://communities.sas.com/t5/ODS-and-Base-Reporting/LOB/m-p/5837#M2358 I have an Oracle table which contains CLOB Data Type.<BR /> Is there any way i can take a value from CLOB into a SAS Variable and Parse or Scan words. <BR /> Is there any easy way to do this? and is there any restriction on the CLOB size to pull it.<BR /> I have SAS 9.1.2 and Access to Oracle.<BR /> Thanks Sat, 08 Dec 2007 14:31:26 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/LOB/m-p/5837#M2358 deleted_user 2007-12-08T14:31:26Z https://communities.sas.com/t5/ODS-and-Base-Reporting/LOB/m-p/5838#M2359 I believe this Tech Support note addresses your issue:<BR /> <A href="http://support.sas.com/kb/4/978.html" target="_blank">http://support.sas.com/kb/4/978.html</A><BR /> <BR /> This is not really an ODS or Base Reporting Procedure (PRINT, REPORT, TABULATE) question, however. If you have further questions, your best bet for further help is to contact Tech Support.<BR /> <BR /> cynthia Sat, 08 Dec 2007 19:13:26 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/LOB/m-p/5838#M2359 Cynthia_sas 2007-12-08T19:13:26Z