Help using Base SAS procedures

A problem with lowercase and uppercase

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

A problem with lowercase and uppercase

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.


Accepted Solutions
Solution
‎11-28-2014 09:55 PM
Trusted Advisor
Posts: 1,128

Re: A problem with lowercase and uppercase

Please try

data X;

set Y;

if upcase(Surv_city)=upcase(city);

run;

Thanks,

Jag

Thanks,
Jag

View solution in original post


All Replies
Solution
‎11-28-2014 09:55 PM
Trusted Advisor
Posts: 1,128

Re: A problem with lowercase and uppercase

Please try

data X;

set Y;

if upcase(Surv_city)=upcase(city);

run;

Thanks,

Jag

Thanks,
Jag
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation