https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919823#M41198 <P>If I have</P> <P>Name:</P> <P>Jack784Jill</P> <P>Animesh56Mardi</P> <P>Len7lenove</P> <P>acer789542aspire</P> <P>and wanted to extract 1st and last name only using scan and compress function&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 11 Mar 2024 18:53:26 GMT animesh123 2024-03-11T18:53:26Z https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919823#M41198 <P>If I have</P> <P>Name:</P> <P>Jack784Jill</P> <P>Animesh56Mardi</P> <P>Len7lenove</P> <P>acer789542aspire</P> <P>and wanted to extract 1st and last name only using scan and compress function&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 11 Mar 2024 18:53:26 GMT https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919823#M41198 animesh123 2024-03-11T18:53:26Z https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919831#M41199 <P>As a minimum you should indicate which part of those values is Last name and which is a first name.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 11 Mar 2024 19:21:31 GMT https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919831#M41199 ballardw 2024-03-11T19:21:31Z https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919845#M41200 <P>Sounds like homework.</P> <P>&nbsp;</P> <P><SPAN class="xisDoc-keyword">SCAN</SPAN><SPAN>(</SPAN><EM class="xisDoc-userSuppliedValue"><A tabindex="0" href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm#p0ctpo1650lomun1cddyc1rodmh1" target="_blank" rel="noopener">string</A></EM><SPAN>,&nbsp;</SPAN><EM class="xisDoc-userSuppliedValue"><A tabindex="0" href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm#p00b11fwb79wk4n1jvl4hiobbcng" target="_blank" rel="noopener">count</A></EM><SPAN>&nbsp;</SPAN><SPAN class="xisDoc-optional">&lt;,<SPAN>&nbsp;</SPAN><EM class="xisDoc-userSuppliedValue"><A tabindex="0" href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm#p13y5i05dpp62pn1p2tl9zlk0wn0" target="_blank" rel="noopener">character-list</A></EM><SPAN>&nbsp;</SPAN>&lt;,<SPAN>&nbsp;</SPAN><EM class="xisDoc-userSuppliedValue"><A tabindex="0" href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm#n125492vxo9uxmn19esm1g0eezji" target="_blank" rel="noopener">modifier</A></EM>&gt;&gt;</SPAN><SPAN>)</SPAN></P> <P>&nbsp;</P> <P>Use&nbsp;<STRONG>d</STRONG> as value for the&nbsp;modifier in&nbsp;<A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0jshdjy2z9zdzn1h7k90u99lyq6.htm" target="_self">scan function</A>&nbsp;to define digits as the word separators, set count to 1 to extract the first word, and to -1 to extract the last word.</P> Mon, 11 Mar 2024 20:03:57 GMT https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919845#M41200 Patrick 2024-03-11T20:03:57Z https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919942#M41204 So as in example<BR />1st_str<BR />Jack<BR />Animesh<BR />Len<BR />Acer<BR /><BR />2nd_str<BR />Jill<BR />Mardi<BR />Lenove<BR /> Tue, 12 Mar 2024 13:36:48 GMT https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919942#M41204 animesh123 2024-03-12T13:36:48Z https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919945#M41205 <P>Which actually does not clarify which is last name and which is first. Plus you have also changed the case of the string but only for some.</P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/430763">@animesh123</a>&nbsp;wrote:<BR />So as in example<BR />1st_str<BR />Jack<BR />Animesh<BR />Len<BR />Acer<BR /><BR />2nd_str<BR />Jill<BR />Mardi<BR />Lenove<BR /><HR /></BLOCKQUOTE> <P>&nbsp;</P> Tue, 12 Mar 2024 13:56:55 GMT https://communities.sas.com/t5/New-SAS-User/Required-to-extract-1st-and-Last-name-from-a-obs-using-scan-and/m-p/919945#M41205 ballardw 2024-03-12T13:56:55Z