请教

shiyiming

我用proc compare过程核对数据库，欲实现某一指标相差在0.1内就认为其没有差异，怎么用oriterion选项好像实现不了该过程啊，在线等！

shiyiming

You got a misspelled 'oriterion'.  It should be [ criterion=0.1 ].  You might need to use method=absolute option.

shiyiming

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

shiyiming

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

thank you very much,i will try it.