12-15-2016 08:06 PM
I have a requirement of proc compare of one SAS dataset against 10 sql tables. This SAS dataset has a total of 64,323,006 records which is copied in 10 SQL tables. Below is the SAS dataset breakup inserted into SQL physical tables.
Next I want to run a proc compare of sas dataset against these 10 sql tables (somehow at proc compare these 10 sql tables should appear as a single dataset. I dont want to download these sql tables into sas dataset but directly compare in as is condition)
Request if anyone can help on this.
12-16-2016 04:25 AM
Create a view
data sqlview / view=sqlview; set sql.table1 sql.table2 ... sql.table10 ; run;
and use that in the compare.
If library sql points to a external RDBMS, the compare might produce unintended results because of differing number storage.