BookmarkSubscribeRSS Feed
mrzd
Calcite | Level 5

Hi! I need to compare the data values between two different table versions, one in 9.1.3. and another in 9.2. Both are SAS datasets. They should have the same values because we just migrated and rerun the jobs. There are a lot of tables involved, more than hundred, each containing a large number of observations. I'm done comparing the row counts between the two tables using dictionary.tables. Now, I need to check the values.

I read about proc compare and tried it in a test job using tables in a same server and answers my problem well. However, can I also use this procedure to compare my large datasets in two different servers without the hassle of sampling, upload and download? I'm using EG by the way.

Thanks!

1 REPLY 1
Peter_C
Rhodochrosite | Level 12

if you can "address" one server from the other you will just need an appropriate libname statement.

Otherwise, SAS/Connect or SAS/Share will enable communications from one server to the other.

Are these licensed?

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1037 views
  • 0 likes
  • 2 in conversation