BookmarkSubscribeRSS Feed
3 REPLIES 3
Reeza
Super User

You can cobble together some string functions, primarily, SUBSTR(), PROPCASE() and UPCASE().  

This would be a brute force method.

 

data want;
input word $;
word2 = catt(propcase(substr(word, 1, length(word)-1)), 
			upcase(substr(word, length(word), 1)));
cards;
word
random
mIxed
CASE
WORDS
;
run;

proc print;run;
ballardw
Super User

Is your actual data going to contain any spaces imbedded?

PGStats
Opal | Level 21

Or harness the power of regular expressions:

 

data have;
length str $40;
input str &;
cards;
word
random
mIxed
CASE
WORDS
Whole string of words.
a ab abc abc-def
;

data want;
if not prx1 then prx1 + prxParse("s/\b(\w?)(\w*)(\w)\b/\u\1\L\2\E\u\3/");
set have;
length StrinG $40;
StrinG = prxChange(prx1, -1, str);
drop prx1;
run;

proc sql; select * from want; quit;
PG

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch 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
  • 3 replies
  • 2509 views
  • 0 likes
  • 4 in conversation