Many To One Merge In SAS
Posted: Wed Jun 17, 2015 6:14 pm
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!
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!