merge statement - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

merge statement

Posted 09-03-2018 04:46 PM (1234 views)

Does a merge statement need a by statement? If not, then when do we use a by statement with the merge statement?

3 REPLIES 3

PROC Star

Re: merge statement

Posted 09-03-2018 05:02 PM (1225 views) | In reply to clq

Read the documentation first: https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n1i8w2bwu1fn5kn1gpxj18xttbb0.htm&doc...

And if it is still not clear, then ask further questions.

Diamond | Level 26

Diamond | Level 26

Re: merge statement

Posted 09-03-2018 08:57 PM (1195 views) | In reply to SASKiwi

Hi:
And in this previous forum posting: https://communities.sas.com/t5/SAS-Programming/Merge-datasets/td-p/463569 are some images and code to explain merge with BY.
Cynthia

Super User

Super User

Re: merge statement

Posted 09-03-2018 11:12 PM (1188 views) | In reply to clq

In addition, the documentation has a section that outlines the different way to combine data sets all side by side with code examples.

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#n1xc1y8c37apw7n1erbi...

It's definitely worth a read.