An SQL union of multiple tables using the UNION operator might fail in SAS SPD Server.

Click the Full Code tab in this SAS Note to see an example of code that produces the following error in the SAS SPD Server log:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

%let dom=spds51;
%let host=myhost.domain;
%let portno=5200;


libname foo sasspds "&dom" host="&host" serv="&portno" user='admin' password='secret' IP=YES LIBGEN=YES;

data foo.class;
 set sashelp.class;
run;

%macro crttab (n_unions);

proc sql;
 create table work.class as
   select * from foo.class
%do i=1 %to &n_unions;
	 union
	select * from foo.class
%end;
;
quit;
%put Unions &n_unions: sqlrc=&sqlrc syserr=&syserr syscc=&syscc; 
%mend;

%crttab(14);

A fix for this issue for SAS Scalable Performance Data Server 5.2 is available at:

A fix for this issue for SAS Scalable Performance Data Server 5.1 is available at: