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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: