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

A PROC SQL query may return an incorrect number of rows when accessing
a table using an index via a SAS/SHARE server.  Below is a sample
query that may show the problem.

  PROC SQL;
    CREATE INDEX KEY ON SHARELIB.TESTDUP1(KEY);
    SELECT DISTINCT CEL_IDH
    FROM SHARELIB.TESTDUP1, SHARELIB.TESTDUP2
    WHERE TESTDUP1.KEY IN ('a','b','c')
    AND TESTDUP1.KEY=TESTDUP2.KEY;
  QUIT;

Dropping the index prevents the problem.  Another circumvention is to
access the table directly rather than through the REMOTE engine.

This problem is fixed in Release 8.2 TSLEVEL 2M0.

A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#004478

Operating System and Release Information

A fix for Release 8.1 (TS1M0) for this issue is available at: