https://communities.sas.com/t5/SAS-Procedures/Label-conversion-logic/m-p/31770#M7576 seems very complicated!<BR /> How should we recognise prepositions?<BR /> Why have you not upgraded to SAS9?<BR /> <BR /> peterC Mon, 07 Jun 2010 07:56:07 GMT Peter_C 2010-06-07T07:56:07Z https://communities.sas.com/t5/SAS-Procedures/Label-conversion-logic/m-p/31769#M7575 Hi All <BR /> I have 100’s of observations in my dataset. I have to convert them into a propcase using 8.2 version <BR /> 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<BR /> <BR /> For ex,this is the string: low level AE term code (Alpha– numeric) – text.<BR /> This is the output: Low Level AE Term Code (Alpha– numeric) – text.<BR /> <BR /> Some strings are like this : medDRA version? Text.<BR /> Output: MedDRA Version? - text.<BR /> <BR /> Some strings are like this: subject eligible to continue in study? text<BR /> Subject Eligible to Continue in study? - text<BR /> <BR /> Thanks in advance for any of the help. Fri, 04 Jun 2010 14:11:55 GMT https://communities.sas.com/t5/SAS-Procedures/Label-conversion-logic/m-p/31769#M7575 keen_sas 2010-06-04T14:11:55Z https://communities.sas.com/t5/SAS-Procedures/Label-conversion-logic/m-p/31770#M7576 seems very complicated!<BR /> How should we recognise prepositions?<BR /> Why have you not upgraded to SAS9?<BR /> <BR /> peterC Mon, 07 Jun 2010 07:56:07 GMT https://communities.sas.com/t5/SAS-Procedures/Label-conversion-logic/m-p/31770#M7576 Peter_C 2010-06-07T07:56:07Z