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

On a machine running MS OFFICE XP, when ODS RTF is used to route PROC
TABULATE output, if the following setting is active:

   Tools..
    Options..
     Preferences..
      Results..
       View results as they are generated

The file may appear to hang as the .rtf file is opened in the Results
Window. This is a problem with the headers being interpreted by
Microsoft Word, and since the Results Viewer is using MS Word, it looks
like SAS is hung. Using Task Manager and viewing Performance, the CPU
usage reports nearly 100%.

The same problem will result if the above option is not active, but the
file is opened directly from Microsoft Word 2002 (XP). This is a problem
with Word's interpretation of the headers generated by Tabulate.
Rearranging the TABLE statement from within PROC TABULATE may minimize
the problem.

   TABLE CLASS1*CLASS2, VAR1;

/* Cirumvention: MOVE CLASS1 to the PAGE dimension */

   TABLE CLASS1, CLASS2, VAR1 / box=_page_;

Microsoft created a hotfix for Microsoft Office Service Pack 2 which is
available by calling 1-800-936-3100 and asking for OfficeQFE8040 or the
hotfix from KB article ID 818791 "WD2002: RTF Files Open Slowly and
Scroll Slowly". They will ask for your name and email address and will
email you the files necessary to install the fix.

This hotfix will be available in the next service pack that is created
for Office XP. Once SP3 is available it will be unnecessary to add the
hotfix.

Operating System and Release Information