BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
renjithr
Quartz | Level 8

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

UPCASE() function

 

if name ne upcase(name) then delete;

 

ANYLOWER() function

 

if anylower(name) > 0 then delete;

 

View solution in original post

3 REPLIES 3
Reeza
Super User

UPCASE() function

 

if name ne upcase(name) then delete;

 

ANYLOWER() function

 

if anylower(name) > 0 then delete;

 

PGStats
Opal | Level 21

Please mark @Reeza's answer as Accepted.

PG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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