Date:         Wed, 17 Jul 2002 01:06:36 -0700
Reply-To:     Xavier Autret <xav_x@NOOS.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Xavier Autret <xav_x@NOOS.FR>
Organization: http://groups.google.com/
Subject:      new notation for me: .X, .Z
Content-Type: text/plain; charset=ISO-8859-1

That s very new for me...
Can someone can explain the null numeric value like .X, .Z ...

Thanks!

Xavier

here are my tests:

*-- Run with no errors --*;
data TEST;
   input x 8.;
   cards;
6
.X
.
.Z
.I
.P
.x
2
;
run;

data ANALYZ;
   length REPORTED $2;
   set TEST(where=(x is null));*-- where clause, will remove only 2 obs --*;
   select (x);
   when (.)
   REPORTED='.';
   when (.X)
   REPORTED='.X';*-- .X value will be correctly handled --*;
   otherwise
   REPORTED='O';
   end;
run;

data SUB;
   set TEST;
   sum+x;*-- Sum will be equal to 8 --*;
run;

*-- 1 obs is removed, .x and .X are equals for SAS --*;
proc sort data=TEST out=dedup nodupkey;
   by x;
run;