Help using Base SAS procedures

Label conversion logic

Reply
Contributor
Posts: 29

Label conversion logic

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.
Valued Guide
Posts: 2,175

Re: Label conversion logic

seems very complicated!
How should we recognise prepositions?
Why have you not upgraded to SAS9?

peterC
Ask a Question
Discussion stats
  • 1 reply
  • 105 views
  • 0 likes
  • 2 in conversation