Hi ,
I am running below program and I am getting error when I run with table b
proc sql;
CONNECT TO ODBC AS tg (DSN = "Test" UID=test2 PWD=&xy);
CREATE TABLE testing AS
SELECT * FROM CONNECTION TO tg (
SELECT a.apple as apple
b.sgsystem as id,
count(*) as hh
FROM zx as a
Gc as b
WHERE a.pol = b.pol
AND a.key = b.key
GROUP BY apple,id );
DISCONNECT FROM tg;
QUIT;
ERROR: CLI open cursor error: [Tandem][ODBC Driver][NonStop SQL] NonStop SQL message (8013) :
Internal error: Unable to increase the size of the SQL executor's extended segment. The
current segment size is 133693440 bytes.illegal <count> specified
Can anyone please help
Thank you so much
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.