How to remove observations with mixed case names?

[renjithr]

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 · Accepted solution]

UPCASE() function

if name ne upcase(name) then delete;

ANYLOWER() function

if anylower(name) > 0 then delete;

[renjithr]

Thank you!

[PGStats]

Please mark @Reeza's answer as Accepted.