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. ... View more

Hi,   I am trying to compare two rows from tables and highlighting mismatch data with color codes, in the output getting color for matched data also see the below example.   in old column and new column contain same data as "0" it should not be highlighted.     old new 4.05.314   0 0 0 0 0 0 5.772   0 0 0 0 0 0 584 584 7.479 7479 1.130 1130 1.236 1236 928 928   i written the below code,   COL old new;   define old / display; define new / display; compute old if (old ne new) then call define (_col_,"style","style={background= orange}"); end compute; ... View more

Hi,   I compared two data sets, want to keep the compared data in one table.   can anyone help me how to display compared data in tabular format in SAS EG.     Thanks in Advance. ... View more

Hi,   Can anyone help me converting from 125,804 to 125804. 2.53.476 253476   Thanks in advance ... View more