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!
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.
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...
I think CASDATALIMIT is a system option. Submit:
options casdatalimit=500M;
before you run your query.
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.
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.