A problem with lowercase and uppercase

m1986MM — Sat, 29 Nov 2014 02:43:17 GMT

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.

Re: A problem with lowercase and uppercase

Jagadishkatam — Sat, 29 Nov 2014 02:55:14 GMT

Please try

data X;

set Y;

if upcase(Surv_city)=upcase(city);

run;

Thanks,

Jag

topic A problem with lowercase and uppercase in SAS Procedures

A problem with lowercase and uppercase

Re: A problem with lowercase and uppercase