Hello, I want to merge more than 1000 datasets in a SAS Library into one (All their names start with V if that helps). SAS generates this error when I run my program "ERROR: CLI error trying to establish connection: The permitted number of client connections(510) has been exceeded". Below is the code I use: proc sql noprint;
/* select memname into : names separated by ' ' */
select catx('.',libname,memname)
into :names separated by ' '
from dictionary.tables
where libname='PD';
data want;
set &names;
run; I also used macro and SQL UNION ALL as an alternative, but then there was this error: "ERROR: The text expression length (65538) exceeds maximum length (65534). The text expression has been truncated to 65534 characters." I guess the problem is that I have way too many datasets. Can you please help me here? About my level of expertise, I'm just a rookie. Many thanks in advance,
... View more
