DATA Step, Macro, Functions and more

How to change any lower case in a string to upper case

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 132
Accepted Solution

How to change any lower case in a string to upper case

I have a character variable that consists of both letter and numbers(i.e. ABC123).

 

I want to convert all observations that have lower case in that variable (i.e. abc124) to upper case (ABC124). Not all observations have lower case. What is the best way to do this? newvar =upcase(oldvar) gives me missing values, I am assuming because I have numbers in my string too.


Accepted Solutions
Solution
‎10-24-2017 04:59 PM
SAS Super FREQ
Posts: 496

Re: How to change any lower case in a string to upper case

Use the upcase function.  It does not matter that values might or might not contain uppercase, lowercase, or numerals.  I don't know what you are doing to get missing values.  You have probably previously defined newvar as numeric.

View solution in original post


All Replies
Solution
‎10-24-2017 04:59 PM
SAS Super FREQ
Posts: 496

Re: How to change any lower case in a string to upper case

Use the upcase function.  It does not matter that values might or might not contain uppercase, lowercase, or numerals.  I don't know what you are doing to get missing values.  You have probably previously defined newvar as numeric.

Super User
Posts: 22,874

Re: How to change any lower case in a string to upper case


Melk wrote:

newvar =upcase(oldvar) gives me missing values, I am assuming because I have numbers in my string too.


No, there's some other reason most likely. If you have mixed types in the cell, that's only possible with a character variable. If your variable is numeric, then UPCASE will definitely not work.

Frequent Contributor
Posts: 132

Re: How to change any lower case in a string to upper case

[ Edited ]

Thanks - I just preceded that line with newvar = " " and that seemed to work for some reason.

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 165 views
  • 2 likes
  • 3 in conversation