topic Re: How do I capitalize characters and replace characters in a variable name? in New SAS User

How do I capitalize characters and replace characters in a variable name?

sasnewbie5 — Fri, 07 Dec 2018 22:27:50 GMT

I have this line of code:

street=catx(' ',scan(line2,2),scan(line2,3));

I need to capitalize all of the characters in the variable and also abbreviate some words in the same variable. I tried using the "upcase" function but had no luck. Can anyone provide assistance in accomplishing this?

Re: How do I capitalize characters and replace characters in a variable name?

PeterClemmensen — Fri, 07 Dec 2018 22:32:46 GMT

What do you mean by abbreviate some words?

Re: How do I capitalize characters and replace characters in a variable name?

sasnewbie5 — Fri, 07 Dec 2018 22:42:18 GMT

Change Road to Rd., Street to St., Avenue to Ave.

Re: How do I capitalize characters and replace characters in a variable name?

PeterClemmensen — Fri, 07 Dec 2018 22:43:20 GMT

And those are the only abbrevaitions?

Re: How do I capitalize characters and replace characters in a variable name?

sasnewbie5 — Fri, 07 Dec 2018 22:44:27 GMT

Yes.

Re: How do I capitalize characters and replace characters in a variable name?

PeterClemmensen — Fri, 07 Dec 2018 22:51:39 GMT

You can use the TRANWRD Function in a do loop as suggested in the thread below

https://communities.sas.com/t5/SAS-Enterprise-Guide/Replacing-Multiple-words-in-a-field-using-TRANWRD/td-p/189375