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. 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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.