如何输入缺失数据的NA [英] how to enter NA for missing data
问题描述
大家好，
我正在使用MS访问数据库来输入和管理来自实验室的数据
测试。
到目前为止，我是唯一一个处理数据的人，因此我不需要对输入的数据丢失进行控制，因为我自己做了我知道
究竟是什么数据丢失了...
问题是我可以拥有尚未输入的数据，或者数据低于检测水平的数据b $ b （所以缺失）。
所有数据字段都指定为数字，因此让人
输入 NA返回一条错误消息。
到目前为止，我确保在确保所有数据都输入了
之后运行了一个查询，查询用NA代替了blancs ;。但是现在还有几个人在数据库上工作，而不是所有人都熟练使用
计算机，所以我要保证输入数据的完整性。
现在正在尝试验证规则，但我似乎无法理解
principels
" iif（IsNumeric（[value]）= TRUE; [value];" NA"）"，无法在
全部工作。
函数IIf和IsNumeric验证规则中不存在。
有没有人知道如何确保
变量的列给我一个数字或者一个" NA"当没有输入
时什么都没有。
亲切的问候，
汤姆。
8月20日下午1:15，Mr.Tom.Will ... @ gmail.com写道：
你好，
我正在使用MS访问数据库来输入和管理来自实验室的数据
测试。
到目前为止，我是唯一一个处理数据的人，所以我不需要对输入数据丢失的方式进行控制，因为我自己做了我知道
究竟是什么数据丢失了...
问题是我可以拥有尚未输入的数据，或者
数据低于检测水平（如此缺失）。
所有数据字段都指定为数字，因此让人
输入 NA返回一条错误消息。
到目前为止，我确保在确保所有数据都输入了
之后运行了一个查询，查询用NA代替了blancs ;。但是现在还有几个人在数据库上工作，而不是所有人都熟练使用
计算机，所以我要保证输入数据的完整性。
现在正在尝试验证规则，但我似乎无法理解
principels
" iif（IsNumeric（[value]）= TRUE; [value];" NA"）"，无法在
全部工作。
函数IIf和IsNumeric验证规则中不存在。
有没有人知道如何确保
变量的列给我一个数字或者一个" NA"或者没有什么，当它没有输入
时。
亲切的问候，
汤姆。
嗨汤姆，
不确定这是否解决了您的问题或数据范围是多少
$ b您输入的$ b属于，但我们通常使用-99。表示某个特定领域缺少数据
。
干杯 - 大卫
< blockquote>考虑使用两列来存储您的数据;您现在拥有的数字列，表示数字结果（例如1.234567），以及
数值的文本表示（例如1.23 ppm） 。
文本表示格式化为显示适当数量的
有效数字。如果结果低于检测结果，则用户可以输入''< DL''或''< 1''等到文本列，留下
数字列为null。这也允许你捕获
不是数字的结果，（例如''正面''，'负面'等）。
De-规范化是有代价的，但在这种情况下它可能是一个值得支付的价值。
先生************ @ gmail.com 写道：
你好，
我正在使用MS访问数据库来输入和管理来自实验室的数据
测试。
到目前为止我是唯一的一个人对数据进行了处理，所以我不需要输入数据丢失的数据，因为我自己做了，我知道
究竟是什么数据丢失了......
问题是我可以拥有尚未输入的数据，或者数据低于检测水平的数据（如此缺失）。
所有数据字段都指定为数字，因此让人
输入 NA返回一条错误消息。
到目前为止，我确保在确保所有数据都输入了
之后运行了一个查询，查询用NA代替了blancs ;。但是现在还有几个人在数据库上工作，而不是所有人都熟练使用
计算机，所以我要保证输入数据的完整性。
现在正在尝试验证规则，但我似乎无法理解
principels
" iif（IsNumeric（[value]）= TRUE; [value];" NA"）"，无法在
全部工作。
函数IIf和IsNumeric验证规则中不存在。
有没有人知道如何确保
变量的列给我一个数字或者一个" NA"什么时候没有，或者什么都没有输入。
亲切的问候，
汤姆。
2007年8月20日星期一05:15:32 -0700，先生************ @ gmail.com 写道：
我不喜欢Daveo的使用建议一个神奇的价值。
我会说：null代表尚未输入的数据。
类似< 0.005"的值。在进行测试时是合适的，并且b $ b值低于检测水平。当然这需要一个
文本字段。您甚至可以让计算机自动输入，如果您有一个分析物表及其检测水平。
因此验证规则仍然很简单：它' '是数字还是它''<""加上
a数。
-Tom。
> Hello people，
我正在使用MS访问数据库来输入和管理来自实验室测试的数据。
直到现在我是唯一一个处理数据的人，所以我不需要一个
关于如何输入缺失数据的控制，因为我自己做了我知道确切地说缺少了什么数据...
问题是我可以拥有尚未输入的数据然而，或者
低于检测水平的数据（如此缺失）。
所有数据字段都指定为数字，因此让人
输入 NA返回错误消息。
到目前为止，我只是在确保输入了所有数据后运行了查询，查询用NA代替了blancs。但现在有几个人在数据库上工作，并不是所有人都熟练使用计算机，所以我要保证输入数据的完整性。
现在正在尝试验证规则，但我似乎不明白
principels
iif（IsNumeric（[value]）= TRUE; [value];" NA"）"，在
all下都不起作用。
函数IIf和IsNumeric在验证规则中不存在。
有谁知道我怎样才能确保
变量的列给我一个数字或一个NA。当它没有进入时什么也没有。
亲切的问候，
汤姆。
Hello people,
I am ussing an MS access database to enter and manage data from lab
tests.
until now i was the only one handeling the data so i had no need for a
controle on how missing data was entered, since i did it myself i knew
exactly what data was missing...
The problem is that i can have data that hasn''t been enterd yet, or
data that is below detection level(so missing).
All the data fields are specified to numeric, so having the person
enter " NA " returns an error message.
Until now, i just ran a query after making sure that all data was
entered, the query replaced the blancs with "NA''s". But now there or
several people working on the database, not all as skilled with
computers, so i wich to insure the integrity of the entered data.
Now is was trying a validation rule but i don''t seem to understand the
principels
" iif( IsNumeric([value])=TRUE; [value];"NA") ", does not work at
all.
the function IIf and IsNumeric don''t exist in validation rules.
Does anybody know how i can make sure that the columns for the
variables give me eigther a number or an "NA" or nothing when it isn''t
entered.
Kind regards,
Tom.
On Aug 20, 1:15 pm, Mr.Tom.Will...@gmail.com wrote:Hello people,
I am ussing an MS access database to enter and manage data from lab
tests.
until now i was the only one handeling the data so i had no need for a
controle on how missing data was entered, since i did it myself i knew
exactly what data was missing...
The problem is that i can have data that hasn''t been enterd yet, or
data that is below detection level(so missing).
All the data fields are specified to numeric, so having the person
enter " NA " returns an error message.
Until now, i just ran a query after making sure that all data was
entered, the query replaced the blancs with "NA''s". But now there or
several people working on the database, not all as skilled with
computers, so i wich to insure the integrity of the entered data.
Now is was trying a validation rule but i don''t seem to understand the
principels
" iif( IsNumeric([value])=TRUE; [value];"NA") ", does not work at
all.
the function IIf and IsNumeric don''t exist in validation rules.
Does anybody know how i can make sure that the columns for the
variables give me eigther a number or an "NA" or nothing when it isn''t
entered.
Kind regards,
Tom.Hi Tom,
Not sure if this solves your problem or what number ranges the data
you enter falls within, but we usually use "-99" to indicate data is
missing for a particular field.
Cheers - David
Consider using two columns to store your data; a numeric column, which
you have now, to represent a numeric result, (e.g. 1.234567), and a
textual representation of the numeric value, (e.g. 1.23 ppm). The
textual representation is formatted to display the appropriate number of
significant figures. In the case of a result that is below detection
users can then enter ''< DL'' or ''< 1'' etc into the text column, leaving
the numeric column as null. This also allows you to capture results that
are not numeric, (e.g. ''positive'', ''negative'' etc).
De-normalization comes at a price but in this case it is probably one
worth paying.
Mr************@gmail.com wrote:Hello people,
I am ussing an MS access database to enter and manage data from lab
tests.
until now i was the only one handeling the data so i had no need for a
controle on how missing data was entered, since i did it myself i knew
exactly what data was missing...
The problem is that i can have data that hasn''t been enterd yet, or
data that is below detection level(so missing).
All the data fields are specified to numeric, so having the person
enter " NA " returns an error message.
Until now, i just ran a query after making sure that all data was
entered, the query replaced the blancs with "NA''s". But now there or
several people working on the database, not all as skilled with
computers, so i wich to insure the integrity of the entered data.
Now is was trying a validation rule but i don''t seem to understand the
principels
" iif( IsNumeric([value])=TRUE; [value];"NA") ", does not work at
all.
the function IIf and IsNumeric don''t exist in validation rules.
Does anybody know how i can make sure that the columns for the
variables give me eigther a number or an "NA" or nothing when it isn''t
entered.
Kind regards,
Tom.
On Mon, 20 Aug 2007 05:15:32 -0700, Mr************@gmail.com wrote:
I don''t like Daveo''s suggestion of using a "magic value".
Rather I would say: null represents data that hasn''t been entered yet.
A value like "<0.005" is appropriate when the test was conducted and
the value was below the detection level. Of course this requires a
text field. You can even have the computer enter this automatically if
you have a table of analytes and their detection level.
So the validation rule remains simple: it''s a number or it''s "<" plus
a number.
-Tom.
>Hello people,
I am ussing an MS access database to enter and manage data from lab
tests.
until now i was the only one handeling the data so i had no need for a
controle on how missing data was entered, since i did it myself i knew
exactly what data was missing...
The problem is that i can have data that hasn''t been enterd yet, or
data that is below detection level(so missing).
All the data fields are specified to numeric, so having the person
enter " NA " returns an error message.
Until now, i just ran a query after making sure that all data was
entered, the query replaced the blancs with "NA''s". But now there or
several people working on the database, not all as skilled with
computers, so i wich to insure the integrity of the entered data.
Now is was trying a validation rule but i don''t seem to understand the
principels
" iif( IsNumeric([value])=TRUE; [value];"NA") ", does not work at
all.
the function IIf and IsNumeric don''t exist in validation rules.
Does anybody know how i can make sure that the columns for the
variables give me eigther a number or an "NA" or nothing when it isn''t
entered.
Kind regards,
Tom.
这篇关于如何输入缺失数据的NA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
