BookmarkSubscribeRSS Feed
Yiting
Quartz | Level 8

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!

3 REPLIES 3
ChrisHemedinger
Community Manager

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.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
Yiting
Quartz | Level 8

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
Community Manager

I think CASDATALIMIT is a system option.  Submit:

 

options casdatalimit=500M;

before you run your query.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 20197 views
  • 2 likes
  • 2 in conversation