Date:         Thu, 17 Apr 1997 08:35:22 -0700
Reply-To:     Lund Peter <Peter.Lund@OFM.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Lund Peter <Peter.Lund@OFM.WA.GOV>
Subject:      Re: How to replace missings
Comments: To: Pat Flickner <flickner@EROLS.COM>
Content-Type: text/plain; charset="us-ascii"

Pat-
   I must disagree.  The missing= option "specifies the character to
PRINT for missing numeric values." (Version 6 Language Guide, pg. 763)
 It has no effect on the values in the dataset.
   Also, we have to assume that the unique non-missing value is not
known before the program is run.  If it is really true that there is
only one non-missing value (and the dataset is not huge) I'd try
something like:
 
proc sql noprint;
   select max(var1) into :maxval
   from test;
quit;
 
data test;
  set test;
  var1 = &maxval;
run;
 
   If the dataset was huge, I might use a data step to check for the
first non-missing value, use CALL SYMPUT to create the macro variable,
and stop the data step at that point.  The second data step above would
be the same.
 
Pete Lund
WA State Office of Financial Management
peter.lund@ofm.wa.gov
 
 
----------
From:  Pat Flickner[SMTP:flickner@EROLS.COM]
Sent:  Wednesday, April 16, 1997 7:44 PM
To:  Multiple recipients of list SAS-L
Subject:  Re: How to replace missings
 
<snip>
 
Aureli, this one's easy:
OPTIONS MISSING='Q'; (Q being your unique value).
Pat Flickner
flickner@erols.com