Hello Everyone
I have two SAS datasets
dataset 1. dataset 2
1. 4
2 5
3 6
I want to stack these on top of each other so that the final dataset looks as follows.
Final dataset
1
2
3
4
5
6
I appreciate your help.
Try
data want;
set dataset1 dataset2;
run;
A single column will only work if 1) the variable has the same name and 2) the same-named variable has the same type (numeric or character) in both data sets.
If the values have different lengths in the two sets you may get a warning about different lengths in the log and possible truncation of the data. Do not ignore that warning. Verify that the result is as needed.
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!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.