Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

The join of a SAS data set with an SQL view can produce different
results.  In order for the problem to occur the view must produce a
cartesian product.

Below is an example of a join which will cause the problem:

       proc sql;
       create table all_j (j integer);
       insert into all_j values (0);
       insert into all_j values (1);
       insert into all_j values (2);
       insert into all_j values (3);

       create table test (i integer, j integer);
       insert into test values (1, 1);
       insert into test values (1, 3);

       create view max_j1 as
       select distinct i, max(j) as max_j from test group by i;

       create table v3 as
       select *
       from all_j, max_j1
       where (( all_j.j < max_j1.max_j)
         and (all_j.j >= max_j1.i))
       ;


Altering the syntax above to make MAX_J1 a table rather then a view will
produce the correct results.


A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007831

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#007831

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: