dm "log; clear; odsresults; clear;"; options linesize=64 nonumber nodate; *********************************************************************; * AUTHOR: Chris Bilder *; * DATE: 6-23-16 *; * PURPOSE: Basic use of merge statement *; *********************************************************************; title1 "Chris Bilder, STAT 850"; *********************************************************************; * Basic use of merge statement; data set1; input name$ response1; datalines; "a" 1 "b" 2 "c" 3 "d" 4 "e" 5 "f" 6 ; run; data set2; input name$ response2; datalines; "a" 10 "a" 11 "b" 20 "c" 30 "d" 40 "e" 50 ; run; data merg_set1; merge set1 set2; by name; run; title2 "Merged set"; proc print data=merg_set1; run;