SAS Institute Alert Note SN-008792

From: SAS Technical Support (tsdlist@unx.sas.com)
Date: Mon Dec 02 2002 - 12:33:20 EST

  • Next message: SAS Technical Support: "(no subject)"

    SN-008792 ***Alert Note***

    Using the TRIM= option creates incorrect values in the OUTTREE= data set
    if any of the VAR variables contain missing values

    Product: SAS/STAT
    Component: CLUSTER procedure
    Priority: ALERT

      PROC CLUSTER copies the values of the VAR variables to the OUTTREE= data
      set. If an observation in the DATA= data set contains missing values
      for any of the VAR statement variables, using the TRIM= option causes
      the nonmissing values to be copied incorrectly. No warnings or error
      messages are produced.

      The statistics produced by PROC CLUSTER are not affected.

      To circumvent the problem, delete observations with missing values for
      the VAR variables from the DATA= data set before running PROC CLUSTER.

      Example:

      In the following data set, the first observation has an X value of 1,
      and a Y value which is missing.

         x y

         1 .
         2 0.97382
         3 0.50758
         4 0.88694
         5 0.68936

      Run PROC CLUSTER using the TRIM= option.

       proc cluster data=test m=average outtree=outtree trim=5 k=3;
             var x y;

      A PROC PRINT of the OUTTREE data set shows that the first observation
      now has an X value of -2.5, which is incorrect. The correct value is 1.
      The value was copied incorrectly because the Y value was missing in the
      DATA= data set.

       -2.5 .
        2.0 0.97382
        3.0 0.50758
        4.0 0.88694
        5.0 0.68936

      To circumvent the problem in this example, delete the first observation
      before running PROC CLUSTER.

    Keywords:
      incorrout incorrstat cluster trim trim= missing proc cluster incorrect
      using the trim= option creates incorrect values in the outtree= data set
      if any of the var variables contain missing values
      008792 8792

    SAS Note Revised On: Thu, 7 Nov 2002

    System Version Reported Version Fixed

    AIX 64 bit 8.2 TS2M0
    AIX 64 bit 9 TSM0
    AIX/6000 7 TSB1
    AIX/6000 8 TSM0
    AIX/6000 8.1 TS1M0
    AIX/6000 8.2 TS2M0
    VM/ESA (CMS) 7 TSB1
    VM/ESA (CMS) 8 TSM0
    VM/ESA (CMS) 8.1 TS1M0
    VM/ESA (CMS) 8.2 TS2M0
    Compaq Tru64 UNIX 7 TSB1
    Compaq Tru64 UNIX 8 TSM0
    Compaq Tru64 UNIX 8.1 TS1M0
    Compaq Tru64 UNIX 8.2 TS2M0
    Compaq Tru64 UNIX 9 TSM0
    HP-UX Operating Systems 7 TSB1
    HP-UX Operating Systems 8 TSM0
    HP-UX Operating Systems 8.1 TS1M0
    HP-UX Operating Systems 8.2 TS2M0
    HP-UX Itanium 9 TSM0
    HP-UX 64 bit 8.2 TS2M0
    HP-UX 64 bit 9 TSM0
    Intel ABI 8 TSM0
    Intel ABI 8.1 TS1M0
    Intel ABI 8.2 TS2M0
    Intel Itanium Processor Family(IPF) 9 TSM0
    Linux 8.2 TS2M0
    Linux 9 TSM0
    MIPS ABI 8 TSM0
    MIPS ABI 8.1 TS1M0
    MIPS ABI 8.2 TS2M0
    OS/390 (MVS) 7 TSB1
    OS/390 (MVS) 8 TSM0
    OS/390 (MVS) 8.1 TS1M0
    OS/390 (MVS) 8.2 TS2M0
    OS/390 (MVS) 9 TSM0
    IBM OS/2 7 TSB1
    IBM OS/2 8 TSM0
    IBM OS/2 8.1 TS1M0
    IBM OS/2 8.2 TS2M0
    Solaris 7 TSB1
    Solaris 8 TSM0
    Solaris 8.1 TS1M0
    Solaris 8.2 TS2M0
    Solaris 64 bit 8.2 TS2M0
    Solaris 64 bit 9 TSM0
    OpenVMS VAX 7 TSB1
    OpenVMS VAX 8 TSM0
    OpenVMS VAX 8.1 TS1M0
    OpenVMS VAX 8.2 TS2M0
    OpenVMS Alpha 7 TSB1
    OpenVMS Alpha 8 TSM0
    OpenVMS Alpha 8.1 TS1M0
    OpenVMS Alpha 8.2 TS2M0
    OpenVMS Alpha 9 TSM0
    Windows NT 7 TSB1
    Windows NT 8 TSM0
    Windows NT 8.1 TS1M0
    Windows NT 8.2 TS2M0
    Windows NT 8.2 TS2M0
    Windows NT 9 TSM0
    Windows 2000 Datacenter Server 8 TSM0
    Windows 2000 Datacenter Server 8.1 TS1M0
    Windows 2000 Datacenter Server 8.2 TS2M0
    Windows 2000 Datacenter Server 8.2 TS2M0
    Windows 2000 Datacenter Server 9 TSM0
    Windows 2000 Professional 8 TSM0
    Windows 2000 Professional 8.1 TS1M0
    Windows 2000 Professional 8.2 TS2M0
    Windows 2000 Professional 8.2 TS2M0
    Windows 2000 Professional 9 TSM0
    Windows 2000 Server and Advanced Server 8 TSM0
    Windows 2000 Server and Advanced Server 8.1 TS1M0
    Windows 2000 Server and Advanced Server 8.2 TS2M0
    Windows 95 7 TSB1
    Windows 95 8 TSM0
    Windows 95 8.1 TS1M0
    Windows 95 8.2 TS2M0
    Windows 98 8 TSM0
    Windows 98 8.1 TS1M0
    Windows 98 8.2 TS2M0
    Windows ME 8.2 TS2M0
    Windows XP 8.2 TS2M0

    No Fixes Available

    +-------------------------------------------------------------------------
    + NOTE: To unsubscribe you must send mail to: LISTSERV@VM.SAS.COM with
    + "SIGNOFF tsnews-l"
    + as the only text in the body of the message (without the double quotes).
    + If you have any questions please send them to TSDLIST@SAS.COM
    +-------------------------------------------------------------------------



    This archive was generated by hypermail 2b29 : Mon Dec 02 2002 - 12:34:00 EST