https://communities.sas.com/t5/SAS-Programming/Merge-or-join-two-tables-on-CAS/m-p/796345#M255530 <P>Hello ,</P> <P>&nbsp; &nbsp; &nbsp; I would suggest you take the free e-learning Programming 1 course. <span class="lia-unicode-emoji" title=":winking_face:">😉</span>&nbsp; Very helpful and last section speaks about joining tables.</P> <P>&nbsp;</P> <P><A href="https://support.sas.com/edu/schedules.html?crs=PROG1&amp;ctry=CA#s1=3" target="_blank">https://support.sas.com/edu/schedules.html?crs=PROG1&amp;ctry=CA#s1=3</A></P> <P>&nbsp;</P> <P>Also we have lots of free videos that you can use to learn how to join tables and working in CAS too.</P> <P><A href="https://video.sas.com/detail/video/6154951158001/sas-tutorial-%7C-introduction-to-cas-and-coding-in-casl-in-sas-viya?q=joining" target="_blank">https://video.sas.com/detail/video/6154951158001/sas-tutorial-%7C-introduction-to-cas-and-coding-in-casl-in-sas-viya?q=joining</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 15 Feb 2022 17:10:14 GMT CarmineVerrell 2022-02-15T17:10:14Z https://communities.sas.com/t5/SAS-Programming/Merge-or-join-two-tables-on-CAS/m-p/796320#M255516 <P>Hello,</P> <P>I have two tables, they have in common only one column which contain data like this</P> <P>0051A</P> <P>8547V</P> <P>1275N</P> <P>9201M</P> <P>How can i merge or join the two tables (kind of inner join).</P> <P>P.S : developping on SAS VIYA</P> <P>&nbsp;</P> <P>Thank you</P> Tue, 15 Feb 2022 16:25:00 GMT https://communities.sas.com/t5/SAS-Programming/Merge-or-join-two-tables-on-CAS/m-p/796320#M255516 aloou 2022-02-15T16:25:00Z https://communities.sas.com/t5/SAS-Programming/Merge-or-join-two-tables-on-CAS/m-p/796345#M255530 <P>Hello ,</P> <P>&nbsp; &nbsp; &nbsp; I would suggest you take the free e-learning Programming 1 course. <span class="lia-unicode-emoji" title=":winking_face:">😉</span>&nbsp; Very helpful and last section speaks about joining tables.</P> <P>&nbsp;</P> <P><A href="https://support.sas.com/edu/schedules.html?crs=PROG1&amp;ctry=CA#s1=3" target="_blank">https://support.sas.com/edu/schedules.html?crs=PROG1&amp;ctry=CA#s1=3</A></P> <P>&nbsp;</P> <P>Also we have lots of free videos that you can use to learn how to join tables and working in CAS too.</P> <P><A href="https://video.sas.com/detail/video/6154951158001/sas-tutorial-%7C-introduction-to-cas-and-coding-in-casl-in-sas-viya?q=joining" target="_blank">https://video.sas.com/detail/video/6154951158001/sas-tutorial-%7C-introduction-to-cas-and-coding-in-casl-in-sas-viya?q=joining</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 15 Feb 2022 17:10:14 GMT https://communities.sas.com/t5/SAS-Programming/Merge-or-join-two-tables-on-CAS/m-p/796345#M255530 CarmineVerrell 2022-02-15T17:10:14Z