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!
Hello,
data want;
set qtr1_sales qtr2_sales qtr3_sales qtr4_sales;
run;
Use PROC APPEND
Paige,
Pardon my ignorance but I'm having trouble making the code work using the Append. I must be missing something simple.
What code are you using?
Hello,
data want;
set qtr1_sales qtr2_sales qtr3_sales qtr4_sales;
run;
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.