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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.