compare the names in the same dataset

[Smitha9]

 I have a dataset A and want to compare mom vs mom_new and dad vs dad_new and comment

check_mom and check_dad. if the names are correct or wrong like follows

Mom  Dad    Mom_new    Dad_new    Check_mom       Check_dad

abc     dher     ABC             Dher           correct                correct

Bcd     sher     bcd             SHER           correct               correct

Fer      Sta       Far             Sta                wrong                correct

thanks in advance

[ballardw · Accepted solution]

Something like this perhaps:

data want;
   set have;
   if upcase(mom)=upcase(mom_new) then Check_mom='Correct';
   else Check_mom='Wrong';
run;

Same logic for dad.

Note: In the long run with SAS you may find that getting a True/False, Yes/No, Right/wrong comparison is better as the numeric 1 (True or yes or correct) and 0 (false no wrong ) in the long run. You can use a format to display any desired text but counting and reporting rates is often much easier with numeric values. Since SAS will return 1/0 as the result of logical comparisons the above code using that coding would be:

data want;
   set have;
   Check_mom = (upcase(mom)=upcase(mom_new));
run;

[svh]

proc sql;
   create table want as
   select *, case when lowcase(mom) = lowcase(mom_new) then 'correct' else 'wrong' end as Check_mom
   from A;
   quit;

I am inferring from the example data that differences in letter case are not to be used to signify a non-match. If that is incorrect, then this code will fail.

The CASE WHEN statement should illustrate how to do this for the "mom" variables, and it should be simple to add another CASE WHEN statement for the other two variables that need this.

This could also be done with a DATA step with a different syntax.