topic Re: name string in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132250#M35955 <HTML><HEAD></HEAD><BODY><P>For these simple examples you can use SCAN with blank as the delimiter since there are no blanks between the last and first name.</P><P></P><P>scan(name,1,' ')</P><P></P><P></P><P>But real names are more complicated than this.&nbsp; What about people with spaces in their first name or last name? Or those that use initials?&nbsp; </P><P><A href="http://espn.go.com/mlb/player/_/id/4695/r.a.-dickey" title="http://espn.go.com/mlb/player/_/id/4695/r.a.-dickey">R.A. Dickey Stats, News, Pictures, Bio, Videos - Toronto Blue Jays - ESPN</A></P></BODY></HTML> Mon, 09 Sep 2013 16:07:51 GMT Tom 2013-09-09T16:07:51Z name string https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132249#M35954 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="331"><TBODY><TR><TD height="17" width="331">SALATA,EDYTA</TD></TR><TR><TD height="17">CORNELL,NANCY A.</TD></TR><TR><TD height="17">ROUNDTREE,WILLA M.</TD></TR></TBODY></TABLE><P>how to remove the middle name listed in the end of the name like A. M. above? </P><P>Thanks!</P></BODY></HTML> Mon, 09 Sep 2013 15:24:37 GMT https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132249#M35954 peppapig 2013-09-09T15:24:37Z Re: name string https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132250#M35955 <HTML><HEAD></HEAD><BODY><P>For these simple examples you can use SCAN with blank as the delimiter since there are no blanks between the last and first name.</P><P></P><P>scan(name,1,' ')</P><P></P><P></P><P>But real names are more complicated than this.&nbsp; What about people with spaces in their first name or last name? Or those that use initials?&nbsp; </P><P><A href="http://espn.go.com/mlb/player/_/id/4695/r.a.-dickey" title="http://espn.go.com/mlb/player/_/id/4695/r.a.-dickey">R.A. Dickey Stats, News, Pictures, Bio, Videos - Toronto Blue Jays - ESPN</A></P></BODY></HTML> Mon, 09 Sep 2013 16:07:51 GMT https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132250#M35955 Tom 2013-09-09T16:07:51Z Re: name string https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132251#M35956 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your great help!</P></BODY></HTML> Tue, 10 Sep 2013 14:09:40 GMT https://communities.sas.com/t5/SAS-Procedures/name-string/m-p/132251#M35956 peppapig 2013-09-10T14:09:40Z