https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673201#M23490 <P>Many thanks PaigeMiller, this solved my problem!</P> Wed, 29 Jul 2020 16:28:07 GMT Tim_sas_ 2020-07-29T16:28:07Z https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673197#M23488 <P>Hello,</P><P>&nbsp;</P><P>I have a very basic question but something seems to be wrong with my code.</P><P>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.</P><P>&nbsp;</P><P>I have tried the following code:</P><PRE><CODE class=" language-sas">Data final; Merge Out_1 Out_2 Out_3; Run;</CODE></PRE><P>There seems to be something wrong with it because the merged file only includes the information from Out_3.</P><P>&nbsp;</P><P>I would be very glad if someone could help me out.</P><P>&nbsp;</P><P>Many thanks,</P><P>&nbsp;</P><P>Tim</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Model.JPG" style="width: 863px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/47775iB6AFB8CCD3AF555D/image-size/large?v=v2&amp;px=999" role="button" title="Model.JPG" alt="Model.JPG" /></span></P> Wed, 29 Jul 2020 16:20:58 GMT https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673197#M23488 Tim_sas_ 2020-07-29T16:20:58Z https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673198#M23489 <P>It sounds like you want SET and not MERGE.</P> Wed, 29 Jul 2020 16:25:14 GMT https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673198#M23489 PaigeMiller 2020-07-29T16:25:14Z https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673201#M23490 <P>Many thanks PaigeMiller, this solved my problem!</P> Wed, 29 Jul 2020 16:28:07 GMT https://communities.sas.com/t5/New-SAS-User/Merge-of-3-data-sets/m-p/673201#M23490 Tim_sas_ 2020-07-29T16:28:07Z