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 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of 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
  • 811 views
  • 2 likes
  • 2 in conversation