BookmarkSubscribeRSS Feed
keen_sas
Quartz | Level 8
Hi All
I have 100’s of observations in my dataset. I have to convert them into a propcase using 8.2 version
The conditions are such that , i should not make an changes to the words that are in upcase( ex AE) and should not make any changes that are present in Parenthesis ex (Alpha– numeric), prepositions should be left as such like ( in, of, to.) and – text should be as it is and the remaining all should be converted to Propcase using 8.2

For ex,this is the string: low level AE term code (Alpha– numeric) – text.
This is the output: Low Level AE Term Code (Alpha– numeric) – text.

Some strings are like this : medDRA version? Text.
Output: MedDRA Version? - text.

Some strings are like this: subject eligible to continue in study? text
Subject Eligible to Continue in study? - text

Thanks in advance for any of the help.
1 REPLY 1
Peter_C
Rhodochrosite | Level 12
seems very complicated!
How should we recognise prepositions?
Why have you not upgraded to SAS9?

peterC

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 982 views
  • 0 likes
  • 2 in conversation