Appending two datasets through proc sql

[BrahmanandaRao]

*Run appending process by SQL;
data apnd1;
input Siteno $ Subid Age;
cards;
S1		101 23
S1		102 46
S1		103 56
;
run;

data apnd2;
input Siteno $ Subid Age;
cards;
S2		201 23
S2		202 46
S2		203 56
;
run;

/*Run Appending*/
proc sql;
insert into apnd1;
select * from apnd2;
quit;

[unison · Accepted solution]

Remove ";" after insert into. As in:

data apnd1;
	input Siteno $ Subid Age;
	cards;
S1 101 23
S1 102 46
S1 103 56
;
run;

data apnd2;
	input Siteno $ Subid Age;
	cards;
S2 201 23
S2 202 46
S2 203 56
;
run;

proc sql;
	insert into apnd1 select * from apnd2;
quit;

proc print noobs data=apnd1;
run;

[BrahmanandaRao]

ThanK you
Unison
In proc append we can append only two datasets in datastep we can append 100 datasets with set statement
so how many datasets we can append using proc sql method like above code

[Kurt_Bremser]

There is no defined limit to the number of INSERT statements you can write in SQL.

But it's wrong that PROC APPEND can only append one dataset in one operation; create a data step view containing all the datasets to be appended, and use that in the DATA= option of PROC APPEND.

[andreas_lds]

Why do you want to write more code than necessary? Proc append is designed for appending dataset, use it!