topic Re: How to use DATALIMIT option in SAS Data Management

How to use DATALIMIT option in CAS

Yiting — Fri, 10 May 2019 12:25:36 GMT

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!

Re: How to use DATALIMIT option

ChrisHemedinger — Fri, 10 May 2019 12:25:01 GMT

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.

Re: How to use DATALIMIT option

Yiting — Fri, 10 May 2019 13:13:18 GMT

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...

Re: How to use DATALIMIT option

ChrisHemedinger — Fri, 10 May 2019 17:59:48 GMT

I think CASDATALIMIT is a system option. Submit:

options casdatalimit=500M;

before you run your query.