Hi,
I have a dataset where I have names in upper case and mixed case. I only want to retain observations with upper case names.
ID Name
1 John Doe1
2 JOHN DOE
3 JOHN DOE1
4 John Doe2
Desired output:
ID Name
2 JOHN DOE
3 JOHN DOE1
Please help.
UPCASE() function
if name ne upcase(name) then delete;
ANYLOWER() function
if anylower(name) > 0 then delete;
UPCASE() function
if name ne upcase(name) then delete;
ANYLOWER() function
if anylower(name) > 0 then delete;
Thank you!
Please mark @Reeza's answer as Accepted.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.