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;

 


 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1162 views
  • 2 likes
  • 2 in conversation