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

Ready to join fellow brilliant minds for the SAS Hackathon?

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