compute is not working as expected , highlights identical data as mismatch

radha1 — Wed, 05 Sep 2018 07:58:11 GMT

Hi Team,

I am trying to compare the same data in the string columns, if it's not equal then return F, if it's equal then retun T using below code , even if the data in the columns are similar, including their lengths

proc sql;
create table TEstst as
select
CODE_UNIT_old , CODE_UNIT,length(CODE_UNIT_old ),length(CODE_UNIT),
case when CODE_UNIT_old ne CODE_UNIT then 'T'
else 'F'
end as result
from MISMATCH
;
quit;

ans then am printing in a HTML , if the data is mimatch then highlight , with below code

COMPUTE CODE_UNIT_old;

IF ( strip(CODE_UNIT_old) ne strip(CODE_UNIT) ) then
call define (_col_,"style","style={background= orange}");
ENDCOMP;

But all rows are highlithed even if they have identical data .

CODE_UNIT_old CODE_UNIT length_0ld length_new result
Fix 1,75% Fix 1,75% 9 9 T
Fix 2,25% Fix 2,25% 9 9 T

Can some one help this issue.

Re: compute is not working as expected , highlights identical data as mismatch

RW9 — Wed, 05 Sep 2018 08:29:13 GMT

Its probably because your specifying _col_ in the define. Hard to say from snippets of code in shouting language. As simpler method would be to create a format and use that, as described in:

http://support.sas.com/resources/papers/proceedings11/290-2011.pdf

You wouldn't need all the compute parts then.

topic Re: compute is not working as expected , highlights identical data as mismatch in SAS Enterprise Guide

compute is not working as expected , highlights identical data as mismatch

Re: compute is not working as expected , highlights identical data as mismatch