topic Re: Specific Question-Merge in SAS Programming https://communities.sas.com/t5/SAS-Programming/Specific-Question-Merge/m-p/98207#M20753 <HTML><HEAD></HEAD><BODY><P>Yes.&nbsp; Sounds like a one to many merge which can be done, easily, with either a datastep or proc sql.&nbsp; If it is a many-to-many merge, you would want to do it with proc sql.</P></BODY></HTML> Wed, 12 Dec 2012 22:37:34 GMT art297 2012-12-12T22:37:34Z Specific Question-Merge https://communities.sas.com/t5/SAS-Programming/Specific-Question-Merge/m-p/98206#M20752 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P>I get a dataset by merging two datasets with Medical record Numbers.</P><P>Can i use the resultant dataset to merge with other dataset by bill&nbsp; number??/</P><P>A single Medical record number can have several bill numbers associated with it</P><P></P><P>Regards</P></BODY></HTML> Wed, 12 Dec 2012 22:15:34 GMT https://communities.sas.com/t5/SAS-Programming/Specific-Question-Merge/m-p/98206#M20752 robertrao 2012-12-12T22:15:34Z Re: Specific Question-Merge https://communities.sas.com/t5/SAS-Programming/Specific-Question-Merge/m-p/98207#M20753 <HTML><HEAD></HEAD><BODY><P>Yes.&nbsp; Sounds like a one to many merge which can be done, easily, with either a datastep or proc sql.&nbsp; If it is a many-to-many merge, you would want to do it with proc sql.</P></BODY></HTML> Wed, 12 Dec 2012 22:37:34 GMT https://communities.sas.com/t5/SAS-Programming/Specific-Question-Merge/m-p/98207#M20753 art297 2012-12-12T22:37:34Z