Merge of 3 data sets

[Tim_sas_]

Hello,

I have a very basic question but something seems to be wrong with my code.

I would like to merge 3 data sets (Out_1, Out_2, Out_3, please see below). All have exactly the same structure (variables) and I would like to create a merged table that includes all 3 datasets.

I have tried the following code:

Data final;
Merge Out_1 Out_2 Out_3;
Run;

There seems to be something wrong with it because the merged file only includes the information from Out_3.

I would be very glad if someone could help me out.

Many thanks,

Tim

[PaigeMiller · Accepted solution]

It sounds like you want SET and not MERGE.

[Tim_sas_]

Many thanks PaigeMiller, this solved my problem!