topic Proc compare (One SAS Dataset against 10 different SQL tables) in SAS Programming

Proc compare (One SAS Dataset against 10 different SQL tables)

aj34321 — Fri, 16 Dec 2016 01:06:45 GMT

Hello All,

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.

Iteration,StartObs,EndObs,TotalObs
1,1,7147000,7147000
2,7147001,14294000,7147000
3,14294001,21441000,7147000
4,21441001,28588000,7147000
5,28588001,35735000,7147000
6,35735001,42882000,7147000
7,42882001,50029000,7147000
8,50029001,57176000,7147000
9,57176001,64323000,7147000
10,64323001,64323006,6

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.

Thanks,

Anil

Re: Proc compare (One SAS Dataset against 10 different SQL tables)

Reeza — Fri, 16 Dec 2016 02:21:53 GMT

10 proc compares?

You can use FIRSTOBS and OBS dataset options to limit your records.

Re: Proc compare (One SAS Dataset against 10 different SQL tables)

Kurt_Bremser — Fri, 16 Dec 2016 09:25:14 GMT

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.