A problem with lowercase and uppercase

[m1986MM]

Hello,

I need to compare the value of two variables, both of them in character format. Like following example:

data X; set Y;

if Surv_city=city;

run;

As you see, I have two variable, Surv_city and city, in dataset Y, and I just want to keep those observations with the same name of Surv_city and city.However, A problem comes up and the result is zero observation. I think the problem occurs  because the names of the city are not in the same form of uppercase and lowercase. How can I fixed this problem?

I greatly appreciate any suggestion.

[Jagadishkatam · Accepted solution]

Please try

data X;

set Y;

if upcase(Surv_city)=upcase(city);

run;

Thanks,

Jag