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;

 


 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

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