Hi All, Please can anyone give me a solution of the following code : (1-(complev(field1,field2)/max(lengthof(field1),lengthof(field2))*100 With field1 value as 1 With field 2 value as NULL or space or no value in it. As per my understanding it has to be (1-(1/1))*100 i.e 0 as output, please can anyone confirm if it is right, my colleague tried it and op was shown as 91.66, not sure how it is possible. How does sas work with space or null values while computing? If i have 1 and null complev should be 1 and max length as 1. Thanks in advance.
... View more