BTW, continuing my research on proc rank -  when I added an ID=_N_ to the TEST input dataset, I did get 9 grops with ranks equal to the original ranks value.   I have no idea or explanation why proc rank changed results. ... View more

http://support.sas.com/documentation/cdl/en/statug/68162/HTML/default/viewer.htm#statug_logistic_details56.htm#statug.logistic.logisticods   The docs list the rules om how the F_ and I_ variables are calculated.    ... View more

Perhaps Else if missing( brand)  then mid =0;   If you have many of these types of operations to do you might consider a custom informat. proc format library=work; invalue missingtext . = 0 other=1; run; data example; x= ' '; yx=input(x,missingtext.); z='anything'; yz=input(z,missingtext.); run; This informat looks at an input string, if it is missing then the result is 0 anything else is 1. Even if the input string has a leading blank the result is one.   For your use then you would have mid=input(brand,missingtext.); NOTE this works if you are interested in knowing that your variable has some text. ... View more

@sree0203 wrote: Yes I used this line in my previous code but later formatted them using format statement as nuemerics...i felt it worked but it seems it didnt....noe tell me how to breakthrough it Format and option missing display do not change underlying values.   something like: data need; set have; array a _numeric_; do i=1 to dim(a); if missing(a[i]) then a[i]=0; end; drop i; run; to actually set the values to 0. Replace _numeric_ with an actual list of numeric variable names if desired.   ... View more