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
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.