Date:         Tue, 24 Feb 2009 09:54:40 +0530
Reply-To:     Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Subject:      Re: Help with String Coding
Comments: To: sasgeek009@gmail.com
In-Reply-To:  <f8f64cc6-88a3-414d-8558-cc30e60e07ae@u38g2000yqe.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

> Yes i have 26 unique names. Each name for each alphabet.
>
> Thanks
>

If that is the case, extract the middle name into a character variable
using SCAN (probably space, . will be the delimiters - I don't know
enough about your data to give you the list), and then do an outer
join with your database to bring in the expanded version of the middle
name.

Regards,
Anindya