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 save with the early bird rate—just $795!
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.