topic Re: Merge datasets in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Merge-datasets/m-p/842853#M82218 <P>It looks like you could use the MERGE statement.&nbsp; What code have to tried?&nbsp; Did you get an error, or wrong result?</P> Mon, 07 Nov 2022 12:48:37 GMT Quentin 2022-11-07T12:48:37Z Merge datasets https://communities.sas.com/t5/SAS-Procedures/Merge-datasets/m-p/842850#M82217 <P>Table 1</P><TABLE><TBODY><TR><TD><P>Postcode</P></TD><TD><P>Town</P></TD><TD><P>Region</P></TD></TR><TR><TD><P>7000</P></TD><TD><P>Town1</P></TD><TD><P>Region1</P></TD></TR><TR><TD><P>7000</P></TD><TD><P>Town2</P></TD><TD><P>Region1</P></TD></TR><TR><TD><P>7100</P></TD><TD><P>Town3</P></TD><TD><P>Region1</P></TD></TR><TR><TD><P>7120</P></TD><TD><P>Town4</P></TD><TD><P>Region2</P></TD></TR><TR><TD><P>7121</P></TD><TD><P>Town5</P></TD><TD><P>Region3</P></TD></TR><TR><TD><P>7121</P></TD><TD><P>Town6</P></TD><TD><P>Region3</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Table 2</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>ClientID</P></TD><TD><P>Postcode</P></TD><TD><P>Postcode</P></TD></TR><TR><TD><P>1</P></TD><TD><P>7000</P></TD><TD><P>Town1</P></TD></TR><TR><TD><P>2</P></TD><TD><P>7000</P></TD><TD><P>Town2</P></TD></TR><TR><TD><P>3</P></TD><TD><P>7121</P></TD><TD><P>Town5</P></TD></TR><TR><TD><P>4</P></TD><TD><P>7121</P></TD><TD><P>Town5</P></TD></TR><TR><TD><P>5</P></TD><TD><P>7100</P></TD><TD><P>Town3</P></TD></TR><TR><TD><P>6</P></TD><TD><P>7101</P></TD><TD><P>Town7</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to merge table 2 with table 1 to identify which regions the patients are from through Postcode and Town columns. Please note different towns could have the same postcode. How should I do this?</P> Mon, 07 Nov 2022 12:35:34 GMT https://communities.sas.com/t5/SAS-Procedures/Merge-datasets/m-p/842850#M82217 Sofia2022 2022-11-07T12:35:34Z Re: Merge datasets https://communities.sas.com/t5/SAS-Procedures/Merge-datasets/m-p/842853#M82218 <P>It looks like you could use the MERGE statement.&nbsp; What code have to tried?&nbsp; Did you get an error, or wrong result?</P> Mon, 07 Nov 2022 12:48:37 GMT https://communities.sas.com/t5/SAS-Procedures/Merge-datasets/m-p/842853#M82218 Quentin 2022-11-07T12:48:37Z