Append data sets together

[anweinbe]

Good morning.

I have 4 separate quarterly files with the same 10 columns in each. 

work.Qtr1_Sales

work.Qtr2_Sales

work.Qtr3_Sales

work.Qtr4_Sales.

I want to create one file that has all of the data showing Qtr2 data below Qtr1. Qtr3 data below Qtr2 etc. 

Thank you!

[PaigeMiller]

Use PROC APPEND

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=proc&docsetTarget=p1bjrbc...

[anweinbe]

Paige, 

Pardon my ignorance but I'm having trouble making the code work using the Append. I must be missing something simple. 

[PaigeMiller]

What code are you using?

[gamotte · Accepted solution]

Hello,

data want;
set qtr1_sales qtr2_sales qtr3_sales qtr4_sales;
run;

[PaigeMiller]

---

@gamotte wrote:

Hello,

data want;
set qtr1_sales qtr2_sales qtr3_sales qtr4_sales;
run;

---

The reason I recommend PROC APPEND is that it is much faster than use the SET statement; this can make a difference if these are huge data sets.

[gamotte]

Good point, I overlooked this difference in performance. The drawback i saw with proc append is the necessity to use as many proc appends as there are datasets to append. A macro can be used though.