https://communities.sas.com/t5/SAS-Programming/insert-a-column-and-display-yes-or-no-with-ID-check-from-two/m-p/435123#M108050 <P>Can you provide brief examples of the data you have and what you want the final table to look like?</P> <P>&nbsp;</P> <P>It isn't clear if you want other values from t2 or not.</P> Thu, 08 Feb 2018 00:09:30 GMT ballardw 2018-02-08T00:09:30Z https://communities.sas.com/t5/SAS-Programming/insert-a-column-and-display-yes-or-no-with-ID-check-from-two/m-p/435120#M108049 <P>i have two tables with t1, t2</P><P>t1 has columns ID (only one time), name</P><P>t2 has ID (has repeated times) ,server, poc</P><P>&nbsp;</P><P>i want to insert a new column in t1 with check if t1.ID matches t2.ID as yes or no only one time.</P> Wed, 07 Feb 2018 23:50:39 GMT https://communities.sas.com/t5/SAS-Programming/insert-a-column-and-display-yes-or-no-with-ID-check-from-two/m-p/435120#M108049 radha009 2018-02-07T23:50:39Z https://communities.sas.com/t5/SAS-Programming/insert-a-column-and-display-yes-or-no-with-ID-check-from-two/m-p/435123#M108050 <P>Can you provide brief examples of the data you have and what you want the final table to look like?</P> <P>&nbsp;</P> <P>It isn't clear if you want other values from t2 or not.</P> Thu, 08 Feb 2018 00:09:30 GMT https://communities.sas.com/t5/SAS-Programming/insert-a-column-and-display-yes-or-no-with-ID-check-from-two/m-p/435123#M108050 ballardw 2018-02-08T00:09:30Z