topic Re: Is there a funtion to adjust the letter capitallization automatically. in SAS Programming

Is there a funtion to adjust the letter capitallization automatically.

blueskyxyz — Tue, 22 Dec 2020 03:06:36 GMT

Is there a funtion to captalize the first letter and terminology, the prepositionis and articles are in lower case?

example:

var='aids is one of the sexually transmitted diseases'

a funtion is called wordcase to adjust the letter capitallization automatically.

wordcase(var)='AIDS is one of the Sexually Transmitted Diseases'

Re: Is there a funtion to adjust the letter capitallization automatically.

ChrisNZ — Tue, 22 Dec 2020 03:28:52 GMT

The closest SAS function is function propcase.

To post-process a string to your needs, you can do something like this:

data T;
  V1='aids is one of the sexually transmitted diseases'
  V2=propcase(V1); 
  V2=prxchange('s/\b(AIDS|NATO|POTUS)\b/\U\1\E/i'          , -1, V2);
  V2=prxchange('s/\b(is|are|one|of|with|the|at)\b/\L\1\E/i', -1, V2);
run;

V2=AIDS is one of the Sexually Transmitted Diseases

Re: Is there a funtion to adjust the letter capitallization automatically.

Astounding — Tue, 22 Dec 2020 12:06:50 GMT

You will need a computer that speaks English. After all, how do you treat:

Pfizer transmitted its data about ABC, a new drug that aids in treatment of AIDS, a Sexually Transmitted Disease

One "aids", one "AIDS", one "transmitted", one "Transmitted"

Re: Is there a funtion to adjust the letter capitallization automatically.

blueskyxyz — Wed, 23 Dec 2020 05:42:32 GMT

hi @ChrisNZ ， thanks.

the array, and some functions, and regEx functions can solve the letter capitallization, hope a new function can do it directly in the future.

Re: Is there a funtion to adjust the letter capitallization automatically.

blueskyxyz — Wed, 23 Dec 2020 05:45:07 GMT

hope there is a new function can do it directly in the future.

Re: Is there a funtion to adjust the letter capitallization automatically.

ChrisNZ — Wed, 23 Dec 2020 05:46:12 GMT

> hope a new function can do it directly in the future.

That won't happen. Every user has a different set of words and logic to process in a specific manner.