topic Re: Varbinary columns in CAS- S3 in SAS Programming

Varbinary columns in CAS- S3

TzufRaifMia — Wed, 31 Jan 2024 12:41:00 GMT

Hey All!

I am training an Image classification model in SAS.
For that, I uploaded images from S3 (Amazon Bucket) into CAS Table.

The problem is- two out of 5 columns (_path_, _image_) are 'varbinary' type, which makes issues.
I am looking for a way to overcome it and being able working with 'path' value (I need to extract the label from it).

Attached are

1. The code I used for uploading from S3,

2. The error I get while trying to work with '_path_' column.

3. _Path_ column props

Will be happy to here your thoughts,

Thanks,

S3 extractcolumn propError

Re: Varbinary columns in CAS- S3

Mazi — Sun, 17 Mar 2024 14:11:57 GMT

Hey, T -

Not sure if you’ve solved this problem?

Have you tried using CASL with the computedVars parameter in some CAS action?

Re: Varbinary columns in CAS- S3

TzufRaifMia — Sun, 17 Mar 2024 14:56:09 GMT

Hey,

Problem solved.

Thanks,

Re: Varbinary columns in CAS- S3

Mazi — Sun, 17 Mar 2024 15:16:19 GMT

Hey T,

I’m curious to know how you solved it, if you don’t mind.

Thanks

Re: Varbinary columns in CAS- S3

Patrick — Sun, 17 Mar 2024 23:55:21 GMT

The CAS Libname Engine doesn't support Varbinary but you can use the Caslib with FedSQL or DS2 syntax instead which both support this data type.