Providing software solutions since 1976

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

• 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 SAS 6.12 format for a CHAR variable is set to blanks when using SQL
Pass-through, and SAS 8.x gives a CHAR variable a format of $n (as is
the case for view descriptors, dynamic libname views, etc.).  Your CHAR
variable value could be shown shorter in V8 than in V6 and PROC
CONTENTS will show a format for SAS 8.x, whereas SAS 6.12 will not show
a format.

The SAS 6.12 format for a NUMBER field is set to BESTn when using SQL
Pass-through, and the SAS 8.x format for a NUMBER field is set to
nothing.

If you would like to keep the V6 functionality, you will need to
perform the following steps for SAS 8.1 on Solaris:

   1) go to
      http://ftp.sas.com/techsup/download/maint/access/oracle/SOL2/8.10
   2) download the module sasioora.v6.fmtfix
   3) cd !SASROOT/sasexe
   4) cp where-file-downloaded-to/sasioora.v6.fmtfix ./sasioora
   5) ls -la   (check to make sure permissions are 755, and if
      not, then change them)
   6) set the system optiom DEBUG=V6_FORMATS in the config file
      or at SAS invocation


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

Operating System and Release Information

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