topic Re: Append data sets together in SAS Programming

Append data sets together

anweinbe — Fri, 13 Dec 2019 15:03:42 GMT

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!

Re: Append data sets together

PaigeMiller — Fri, 13 Dec 2019 15:05:23 GMT

Use PROC APPEND

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=proc&docsetTarget=p1bjrbc5esr90on12o8vs7gyv8ue.htm&locale=en

Re: Append data sets together

anweinbe — Fri, 13 Dec 2019 15:09:29 GMT

Paige,

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

Re: Append data sets together

PaigeMiller — Fri, 13 Dec 2019 15:12:31 GMT

What code are you using?

Re: Append data sets together

gamotte — Fri, 13 Dec 2019 15:19:57 GMT

Hello,

data want;
set qtr1_sales qtr2_sales qtr3_sales qtr4_sales;
run;

Re: Append data sets together

PaigeMiller — Fri, 13 Dec 2019 15:22:35 GMT

@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.

Re: Append data sets together

gamotte — Fri, 13 Dec 2019 16:00:48 GMT

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.