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

When reading a Micrsoft Access 97 file into 8.2 by using DDE, the last
character in the last observation is dropped.  This did not happen in
Release 6.12. It does not happen when using Microsoft Access 2000
tables.

This is an example of the code:

FILENAME SWEEK DDE "MSACCESS|D:\TEST\test.MDB;TABLE SAMPLE!ALL";

data sasuser.O_WEEK;
        length WEEK WK_ENDDT $8;
        infile SWEEK dlm='09'x notab dsd missover firstobs=2 ;
        input  WEEK WK_ENDDT;
run;

This is how the last observation appears in Release 6.12 in the output
window:

WEEK         WK_ENDDT
----         --------
199852       12/26/98

This is how the last observation appears in Release 8.2 in the output
window:

WEEK         WK_ENDDT
----         --------
199852       12/26/9


To circumvent this problem, use Microsoft Access 2000 instead of
Microsoft Access 97.


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#005237

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#005237

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: