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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.