How to use DATALIMIT option in CAS

[Yiting]

Hi,

I made an inner join and got error message as below.

ERROR: The maximum allowed bytes (104857600) of data have been fetched from Cloud Analytic Services. Use the DATALIMIT option to
increase the maximum value.
2 The SAS System 12:47 Friday, May 10, 2019

ERROR: PROC SQL runtime error for operation=sqxsrc.
ERROR: An error has occurred.

I added DATALIMIT = ALL in the option window, but it doesnt work.

What shall I do with this? Thanks in advance!

[ChrisHemedinger]

See the documentation for the CAS LIBNAME statement here.

And the DATALIMIT= option.  But you might want to revisit that query, as it looks like you're moving a lot of data.

[Yiting]

Hi, I have checked that DATALIMIT page. And tried with DATALIMIT = ALL or CASDATALIMIT = ALL in the Option window in Query, but got 

ERROR: Invalid option name CASDATALIMIT. or ERROR: Invalid option name DATALIMIT... 

[ChrisHemedinger]

I think CASDATALIMIT is a system option.  Submit:

options casdatalimit=500M;

before you run your query.