Hello all.
I'm a long-time friend of formats, and I was puzzled when this strange thing appened to one of my clients. I can't figure any explanation to this ; maybe one of you would have an idea ?
Question is sent to Tech Support in France, but no answer yet.
The thing is :
1) I create to different formats, which only differ in an extra interval for one of them ;
2) I compute a value which is approximately -50 (due to roundings, the true value is not exactly -50 but I don't think this is really the point, or at least not the ONLY problem)
3) I use these two formats on the same value, and in spite of the same definition of intervals for value -50 in both formats, I end up with two DIFFERENT values !
Amazing, isn't it ?
Here is my sample program :
proc format ;
value pcta -80-<-50 = "A "
-50-<-10 = "B "
-10-high= "X "
;
value pctb -80-<-50 = "A "
-50-<-10 = "B "
;
run;
data test;
x = 3.4-2.8;
y = 2.9-2.6;
pcta = (y-x)/x*100;
run;
proc sql ;
select PUT(pctA,pcta.), PUT(pctA,pctb.)
from test
;
quit ;
Any ideas welcome !
Regards
Olivier