Date:         Mon, 4 Mar 2002 14:51:32 -0800
Reply-To:     MNess@CROMEDICA.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Matthew Ness <MNess@CROMEDICA.COM>
Subject:      Re: Seperating a full name into first and last
Content-type: text/plain; charset=us-ascii

Provided that all your names turn up in the same format as your example,
the scan function should work well here:

data a;
     full='Meyer, David P.';
     run;

data b;
     set a;
     last=scan(full,1);
     first=scan(full,2);
     middle=scan(full,3);
     run;

HTH,
Matt




                    Dave Meyer
                    <dmeyer@HOAGHOS       To:     SAS-L@LISTSERV.UGA.EDU
                    PITAL.ORG>            cc:
                    Sent by:              Subject:     Seperating a full name into first and
                    "SAS(r)                last
                    Discussion"
                    <SAS-L@LISTSERV
                    .UGA.EDU>


                    03/04/02 02:15
                    PM
                    Please respond
                    to Dave Meyer






This is probably a shockingly basic question but...I am having trouble
parsing a full name into seperate first, middle, last.  Could anyone
point me in the direction of a specific function?  Thanks - Dave

ex:

Var "Full_Nam" = Meyer, David P

into

Var "Last" = Meyer
Var "First" = David
Var "Middle" = P



--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG