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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.