topic how to use blobthreshold option with SQLserver data source in SAS Programming

how to use blobthreshold option with SQLserver data source

yatinrao — Mon, 26 Oct 2020 20:03:21 GMT

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

Re: how to use blobthreshold option with SQLserver data source

JosvanderVelden — Tue, 27 Oct 2020 10:15:22 GMT

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

Re: how to use blobthreshold option with SQLserver data source

yatinrao — Tue, 27 Oct 2020 12:49:14 GMT

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

Re: how to use blobthreshold option with SQLserver data source

JosvanderVelden — Tue, 27 Oct 2020 14:52:40 GMT

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