topic Querying two tables in two different databases in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Querying-two-tables-in-two-different-databases/m-p/213548#M16021 <HTML><HEAD></HEAD><BODY><P>HI </P><P>i just want to check the variables in two different tables in two different databases like one in production and one in test( development ) . Is there any procedure in Sas and also procedure in SQL . Can anyone help </P></BODY></HTML> Wed, 29 Jul 2015 19:25:05 GMT chennupriya 2015-07-29T19:25:05Z Querying two tables in two different databases https://communities.sas.com/t5/SAS-Enterprise-Guide/Querying-two-tables-in-two-different-databases/m-p/213548#M16021 <HTML><HEAD></HEAD><BODY><P>HI </P><P>i just want to check the variables in two different tables in two different databases like one in production and one in test( development ) . Is there any procedure in Sas and also procedure in SQL . Can anyone help </P></BODY></HTML> Wed, 29 Jul 2015 19:25:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Querying-two-tables-in-two-different-databases/m-p/213548#M16021 chennupriya 2015-07-29T19:25:05Z Re: Querying two tables in two different databases https://communities.sas.com/t5/SAS-Enterprise-Guide/Querying-two-tables-in-two-different-databases/m-p/213549#M16022 <HTML><HEAD></HEAD><BODY><P>What do you mean by "check the variables"? Do you want to compare two tables that have common rows and variables? If so then I highly recommend PROC COMPARE.</P></BODY></HTML> Wed, 29 Jul 2015 19:37:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Querying-two-tables-in-two-different-databases/m-p/213549#M16022 SASKiwi 2015-07-29T19:37:03Z