topic Re: Appending two datasets through proc sql in Statistical Procedures

Appending two datasets through proc sql

BrahmanandaRao — Thu, 29 Oct 2020 05:09:55 GMT

*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;

Re: Appending two datasets through proc sql

unison — Thu, 29 Oct 2020 05:31:00 GMT

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;

Re: Appending two datasets through proc sql

andreas_lds — Thu, 29 Oct 2020 05:34:32 GMT

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

Re: Appending two datasets through proc sql

BrahmanandaRao — Thu, 29 Oct 2020 06:14:31 GMT

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

Re: Appending two datasets through proc sql

Kurt_Bremser — Thu, 29 Oct 2020 06:30:41 GMT

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.