cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
chennupriya
Quartz | Level 8 chennupriya
Quartz | Level 8

Querying two tables in two different databases

Posted 07-29-2015 03:25 PM (861 views)

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

0 Likes
Reply
1 REPLY 1
SASKiwi
PROC Star SASKiwi
PROC Star

Re: Querying two tables in two different databases

Posted 07-29-2015 03:37 PM (797 views)  |   In reply to chennupriya

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.

0 Likes
Reply

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Watch SAS Enterprise Guide vs. SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • ‎07-29-2015 03:25 PM
  • 862 views
  • 0 likes
  • 2 in conversation