SAS Note SN-001583

From: tsdlist@UNX.SAS.COM
Date: Mon Jan 17 2000 - 11:30:43 EST

  • Next message: tsdlist@UNX.SAS.COM: "SAS Institute's Technical Support closed due to inclement weather"

    >>>>>>>> SAS Notes -- Copyright (c) 1991 - 1999 by SAS Institute Inc. <<<<<<<<

    SAS Note: 001583 ***ALERT NOTE*** Product: BASE

    Title:
    Multiple statistics w/alias under analysis variable may be incorrect

    Keywords:
    MULTIPLE STATISTICS ALIAS PROC REPORT ANALYSIS ACROSS INCORRECT WRONG
    COMPUTED RIGHT COLUMN STATEMENT

    Text:
    If more than one statistic with an alias is specified under an analysis
    variable and there is a computed variable to the right on the column
    statement, the reported statistics will be equal to the first stated
    statistic value. For example:

        COL analysis,(statistic1=alias1...statisticN=aliasN) computed
    OR COL analysis,statistic1=alias1 analysisN,statisticN=aliasN computed

    There are 2 possible workarounds.

    1) state the analysis variable and the alias separately on the column
       statement and then use the define statement to specify the statistic

       For example: COL analysis1=a1 analysisN=aN computed;
                     Define a1 / statistic; Define aN / statistic;

    2) use the NOALIAS option on the PROC REPORT statement. NOTE: if the
       NOALIAS option is used then any reference to the alias in a compute
       block will need to use analysis.statistic form (not the alias name)

    +------------REPORTED------------+ +------FIXED-----+
    System Version Level Version Level

    AIX/R 7 P1
    AIX/R 8 M0
    CMS 7 P1
    CMS 8 M0
    DigitUnx 7 P1
    DigitUnx 8 M0
    HP800 7 P1
    HP800 8 M0
    IABI 8 M0
    MIPS ABI 8 M0
    MVS 7 P1
    MVS 8 M0
    OS/2 7 P1
    OS/2 8 M0
    Solaris 7 P1
    Solaris 8 M0
    VMS 7 P1
    VMS 8 M0
    VMS/AXP 7 P1
    VMS/AXP 8 M0
    WIN/NT 7 P1
    WIN/NT 8 M0
    Win95 7 P1
    Win95 8 M0
    Win98 7 P1
    Win98 8 M0



    This archive was generated by hypermail 2b29 : Mon Jan 17 2000 - 11:32:56 EST