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

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 706 views
  • 0 likes
  • 2 in conversation