Page 1 of 1

Many To One Merge In SAS

Posted: Wed Jun 17, 2015 6:14 pm
by shymaherold
Hello Everyone,

Can anyone help me on below merge query on SAS? I need to merge the below 2 data sets using SAS and the output should be displayed like below:

Input Data set-1 with Policy number

Policy Number:
100001
100002
100003

Input Data set-2 with Policy Number & Country Code

Policy Number Country Code
100001 SA
100001 HA
100001 YA
100002 AA
100002 BB
100003 DD


Output : Data set

Policy Number Country Code
100001 SA HA YA
100002 AA BB
100003 DD

Thank You!