topic Re: How to remove observations with mixed case names? in SAS Programming

How to remove observations with mixed case names?

renjithr — Mon, 28 Mar 2016 20:19:40 GMT

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.

Reeza — Mon, 28 Mar 2016 20:29:10 GMT

UPCASE() function

if name ne upcase(name) then delete;

ANYLOWER() function

if anylower(name) > 0 then delete;

renjithr — Mon, 28 Mar 2016 20:42:08 GMT

Thank you!

PGStats — Mon, 28 Mar 2016 20:45:44 GMT

Please mark @Reeza's answer as Accepted.