topic Re: Tranwrd for multiple values in SAS Data Management

Tranwrd for multiple values

Ujjawal — Mon, 23 Jun 2014 17:23:50 GMT

I want to group some values into one value. For eg : I have data for college names and some names are written in short form and some in full forms. The task is to group them into one name. I am using TRANWRD function to do it. Is it possible to group multiple values into one using TRANWRD function? I know the two datasets can be merged for it.

Re: Tranwrd for multiple values

ballardw — Mon, 23 Jun 2014 19:45:51 GMT

Examples of what you have and what you want. Depending on the number of records you might be able to create a format but tranwrd isn't going to get you there without a many lines of code though it can regularize some things common contractions to a single standard.

Re: Tranwrd for multiple values

Ksharp — Tue, 24 Jun 2014 14:14:18 GMT

You need multiple tranwrd() for that purpose . But you can combine them all into one function :

if prxmatch('/ArthurT|ArthurC|ArthurK/',name) then name='Arthur' ;

Xia Keshan

Re: Tranwrd for multiple values

LinusH — Tue, 24 Jun 2014 20:03:26 GMT

I think you are on the wrong track. Spelling variations will most likely expand over time, and you don't to update your program each time.

Use a look-up table with incorrect - correct (normalized) spelling pairs. Then use the look-up technique you feel most comfortable with (user defined formats, SQL join etc).

Re: Tranwrd for multiple values

Albert_Feng — Wed, 25 Jun 2014 02:24:03 GMT

I think Ksharp may be right, using regular expression is a good way~~~

Re: Tranwrd for multiple values

Ujjawal — Thu, 26 Jun 2014 17:05:15 GMT

Thanks a ton Ksharp. It works like a charm 🙂