topic Re: Converting Text to "Proper" English in SAS Programming

Converting Text to "Proper" English

BCNAV — Mon, 07 Oct 2019 13:50:27 GMT

I have a variable called NAME

In it are geographical locations all in CAPS

Example:

LESTER B. PEARSON

VAL-DOR

NORTH BAY

Is there a SAS format for text that will convert these to:

Lester B. Pearson

Val-Dor

North Bay

thanks

Re: Converting Text to "Proper" English

maguiremq — Mon, 07 Oct 2019 13:53:53 GMT

data have;
input geo $50.;
datalines;
LESTER B. PEARSON
VAL-DOR
NORTH BAY
;
run;

data want;
set have;
geo2 = propcase(geo);
run;

Re: Converting Text to "Proper" English

FreelanceReinh — Mon, 07 Oct 2019 14:00:16 GMT

You can use the PROPCASE function proposed by @maguiremq to create such a format:

proc format;
value $propcase (default=200)
other=[propcase()];
run;

data have;
input name $60.;
cards;
LESTER B. PEARSON
VAL-DOR
NORTH BAY
;

proc print data=have;
format name $propcase.;
run;

Re: Converting Text to "Proper" English

BCNAV — Mon, 07 Oct 2019 14:52:35 GMT

thanks!