BookmarkSubscribeRSS Feed
vishalrajpoot3
Obsidian | Level 7

From the below string how can I count the no of upcase letter?

 

data abc;
input name$30.;
datalines;
Name is Good
Name SHould Change
Name NOT Changed
;run;

 

1 REPLY 1
Reeza
Super User

1. Remove all lower case letters via REGEX or COMPRESS and count the length of the string
2. Convert it to all upper/lower case and see how many characters differ

3. Use COUNTC() with capitalized letters and the modifiers to avoid listing all letters - your best option

Typically when faced with a problem like this, I'll look through the SAS Functions by Category list and take a quick scan through all the character functions to see which ones could help me out.

 

Edited: to add countc() option.

 


@vishalrajpoot3 wrote:

From the below string how can I count the no of upcase letter?

 

data abc;
input name$30.;
datalines;
Name is Good
Name SHould Change
Name NOT Changed
;run;

 


 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1 reply
  • 592 views
  • 2 likes
  • 2 in conversation