Desktop productivity for business analysts and programmers

Querying two tables in two different databases

Reply
Frequent Contributor
Posts: 120

Querying two tables in two different databases

HI

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

Respected Advisor
Posts: 3,059

Re: Querying two tables in two different databases

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.

Ask a Question
Discussion stats
  • 1 reply
  • 224 views
  • 0 likes
  • 2 in conversation