cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AMIN_DA
‎04-08-2018
  • 3 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: How to compare two character fields to check if they are equal

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-09-2017 11:56 PM
‎11-09-2017 11:56 PM
it was fixed by COMPARE(TRIM(UPCASE(Add1 )), TRIM(UPCASE( Add2))) thanks again Reeza ... View more

Re: How to compare two character fields to check if they are equal

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-09-2017 11:13 PM
‎11-09-2017 11:13 PM
Thank you Reeza for replying quickly. I changed the format to $hex32. and I see they are different as below in the 9th postion from left and some other letters as well inside the string. Add1 Add2 11 JANE ST 11 JANE ST 3131204A616E65205374202020202020 3131204A414E45205354202020202020   I have not with HEX format before and not sure if I've got your advice right and also I dont know how to recognise if it is because of space or not. So could you please let me know how I can remove potential space inside the text if there is any solution? Regards, ... View more

How to compare two character fields to check if they are equal

by Fluorite | Level 6 in SAS Enterprise Guide
‎11-09-2017 10:37 PM
‎11-09-2017 10:37 PM
Hi All, I would like to check if 2 addresses are equal. I am using Compare function but for the ones I assume they are equal instead of 0 I get a number. here is my example: Add1 Add2 11 JANE ST 11 JANE ST   compare(Add1,Add2) but instread of 0 it SAS EG gives me 5. I checked in Excel and Excel resut is these 2 are equal.   Would you please help out with this issu? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-08-2018 10:46 AM
Quick links