merge statement - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

merge statement

Posted 09-03-2018 04:46 PM (1273 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 (1264 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 (1234 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 (1227 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.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!