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-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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