how to use blobthreshold option with SQLserver data source

[yatinrao]

Hello 

I am trying to Load a SQL server table to CAS. I was informed by SAS support that SAS does not support SQLServer TEXT type  column and suggested using blobthreshold=1024 as option .  Has anyone used this option with proc casutil load or proc cas loadtable ? 

I can bypass the "TEXT" column by creating a varlist for load but would like to know if this blobthreshold option has worked for someone ?

Thanks 

Yatin 

[JosvanderVelden]

Have a look at the information in the link: https://support.sas.com/kb/62/722.html
Does that respond your question?

Best regards, Jos

[yatinrao]

Jos

That was my original source . This option is not available when you use proc casutil load option. I tried to use it with Loadtable Action but it would not work
here is what I tried to do

proc cas;
ACTION loadtable /
CASLIB="CLOUDTST" ,PATH="GROUPS" , CASOUT={CASLIB="TESTLIB",NAME="GROUPS2"} ,
OPTIONS={CONOPTS="BLOBTHRESHOLD=1024"};

OPTIONS=(BLOBTHRESHOLD=2048);
quit;

I tried variation off the options statement but it would not work
CLOUDTST is my ODBC sqlserver connection, Groups is the table name
testlib is the destination caslib .

let me know if you can think of something

Thanks
Yatin

[JosvanderVelden]

Have you tried something like this?:
proc cas;
ACTION loadtable /
CASLIB="CLOUDTST"
PATH="GROUPS"
OPTIONS={BLOBTHRESHOLD=2048}
CASOUT={CASLIB="TESTLIB",NAME="GROUPS2"};
quit;