https://communities.sas.com/t5/SAS-Enterprise-Guide/Data-Format/m-p/69355#M6929 Use the SCAN function in a DATA step to pick-off the third parsed sub-field, while having the "/" listed as the delimiter.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SCAN Function<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000214639.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000214639.htm</A> Fri, 04 Sep 2009 01:49:41 GMT sbb 2009-09-04T01:49:41Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Data-Format/m-p/69354#M6928 I have a column with incoming url link. How can I get the domain name from the url using SAS<BR /> <BR /> The data in the column looks like<BR /> <BR /> <A href="http://bookmarks.yahoo.com/pages/fid/788?b=1&amp;orderby=title&amp;sort=ASC&amp;savestate=1" target="_blank">http://bookmarks.yahoo.com/pages/fid/788?b=1&amp;orderby=title&amp;sort=ASC&amp;savestate=1</A><BR /> <BR /> If I just need "bookmarks.yahoo.com" in the column how could i use SAS to do it.<BR /> <BR /> Thanks for your help! Fri, 04 Sep 2009 01:11:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Data-Format/m-p/69354#M6928 deleted_user 2009-09-04T01:11:38Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Data-Format/m-p/69355#M6929 Use the SCAN function in a DATA step to pick-off the third parsed sub-field, while having the "/" listed as the delimiter.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> SCAN Function<BR /> <A href="http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000214639.htm" target="_blank">http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000214639.htm</A> Fri, 04 Sep 2009 01:49:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Data-Format/m-p/69355#M6929 sbb 2009-09-04T01:49:41Z