topic Re: Merging SAS datasets in SAS Data Management

Merging SAS datasets

GreenTree1 — Wed, 29 Apr 2020 03:21:21 GMT

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

I appreciate your help.

Re: Merging SAS datasets

sustagens — Wed, 29 Apr 2020 03:44:00 GMT

Try

data want;
set dataset1 dataset2;
run;

Re: Merging SAS datasets

ballardw — Wed, 29 Apr 2020 04:50:55 GMT

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.

Re: Merging SAS datasets

GreenTree1 — Thu, 30 Apr 2020 22:58:20 GMT

Perfect, It worked!! thanks sustagens

Re: Merging SAS datasets

GreenTree1 — Thu, 30 Apr 2020 22:59:53 GMT

Thank you for pointing this Ballardw, the datasets were identical in variables and variable type so it worked out well