SAS中文论坛

标题: 请教 [打印本页]

作者: shiyiming 时间: 2006-6-8 11:56
标题: 请教
我用proc compare过程核对数据库，欲实现某一指标相差在0.1内就认为其没有差异，怎么用oriterion选项好像实现不了该过程啊，在线等！

作者: shiyiming 时间: 2006-6-9 02:45
标题: RE
You got a misspelled 'oriterion'. It should be [ criterion=0.1 ]. You might need to use method=absolute option.

作者: shiyiming 时间: 2006-6-9 08:27
标题: 请教
对不起，我的理解能力＆英文能力都让我无法读明白你的提示，但我在程序中加了criterion=0.1后，没有CompareDifferences结果了，但我看书上有这样一句话，若用户规定选项criterion= ，则隐含值为method=relative，还望指教啊，在线等

作者: shiyiming 时间: 2006-6-10 05:06
标题: replay
Choosing CRITERION=ABSOLUTE or RELATIVE is depended on how to explain your data.  Below formulas give you some ideas.

The ABSOLUTE method compares the absolute difference to the value specified by CRITERION=.

[img:f8309]http://www.uc.edu/sashtml/proc/images/deqn1.gif[/img:f8309]

The RELATIVE method compares the absolute relative difference to the value specified by CRITERION=

[img:f8309]http://www.uc.edu/sashtml/proc/images/deqn2.gif[/img:f8309]

For example:
[code:f8309]
data a; x=10.1; run;
data b; x=10.2; run;

/** To check minium difference downward to one decimal point (0.1),  you may set  criteria=0.09 with  method=absolute option .  If set  criteria=0.1, you will not get the result.  */

PROC COMPARE BASE=a C=b BRIEF
  criteria=.09 method=absolute
  out=DIFF OUTBASE OUTCOMPOUTNOEQUAL OUTDIF;
RUN;[/code:f8309]

作者: shiyiming 时间: 2006-6-10 10:45
标题: 请教
thank you very much,i will try it.

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)