Re: Need modern version of old technique to show missing values



On Jan 6, 11:02 pm, Terence <tbwri...@xxxxxxxxx> wrote:
....
BUT: several programs specialise in statistics for incomplete data
("missing values").
Now: an ascii or formatted file record can be checked in each field
for "just blanks" to indicate the value is unknown.
So here I interpose a read of a character string and then process it
for "blank" fields before extracting values. But not so, in general
today, when reading binary files or unformatted file records.

In what I now have to call "the old days", you could have a positive
zero for a real value of zero and a negative real zero to indicate
this "missing value". These BMD programs utilized that trick.

Can someone suggest me, a way of coding a binary representation of a
floating-point field in such a way as I can detect that this value is
to indicate "not known", without confusing the arithmetic of the
statistics?
Obviously any user "today" will have to be able to easily produce his
data with this interior coding.
I need a coding method such that a simple test can decide if this
really is a floating point value or else the signal that the value is
"missing".
....

For the internal representation you'll have to pick a convention that
suits.

Just a couple of thoughts on the user input for missing data--

SAS uses just a "." in the field for free format, either blank/empty
field or the dot in fixed format fields.

Matlab uses NaN but propogates NaN unless coded to exclude them. It
accepts the string "NaN" in numeric input.

I've not tested w/ a compiler and the LRF manual I have at hand
doesn't seem to specifically indicate whether Fortran input requires
keeping the minus for formatted input of "-0.0"???
If it did, that would probably be the simplest to code but I
personally like the appearance of the "." (but I'm conditioned w/ 20
years of exposure to SAS starting almost 40 years ago).

FWIW (which may be even less than paid :) )...

--

--
.



Relevant Pages

  • Re: DataView Web parts
    ... menu on right click is Format Item As. ... > to do to actually make it a functioning WSS W eb Part. ... > assume there's one last step I'm missing. ... I opened the page in the browser and what was created as the Data View ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Newbie Question about sequence multiplication
    ... Scott wrote: ... Now it looks pretty weird in this format but it was copied exactly from IDLE ... There's a plus sign missing just here ..| ... That doesn't look like a compiler error message! ...
    (comp.lang.python)
  • Re: Formatting numbers with leading and trailing zeros
    ... If the missing leading and/or trailing zeroes were consistent in how many were missing, then the suggestion David gave you would be the way to restore them; however, if the number of leading and/or trailing zeroes can vary within a given column, then there is nothing you can do to restore the information that is not there. ... If you want to format all the numbers with 2 decimal places you can do that. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: What Advantages Does .docx have over .doc? Any?
    ... A Word .doc file saved to .docx should shrink by about 75 per cent. ... If you have tracked changes on and you MOVE a picture, ... The .docx format is compressed Unicode text, ... Am I missing something? ...
    (microsoft.public.mac.office.word)
  • Re: Missing tools in SSMS 2005
    ... >I am using SSMS since a few weeks, and I found it is missing a few ... > The worst of all, anyway, is that we still can't apply a customized format ... > to the sql documents. ... > tool and a tool to recommend. ...
    (microsoft.public.sqlserver.tools)