Desktop productivity for business analysts and programmers

Data Format!

Reply
N/A
Posts: 0

Data Format!

I have a column with incoming url link. How can I get the domain name from the url using SAS

The data in the column looks like

http://bookmarks.yahoo.com/pages/fid/788?b=1&orderby=title&sort=ASC&savestate=1

If I just need "bookmarks.yahoo.com" in the column how could i use SAS to do it.

Thanks for your help!
Super Contributor
Super Contributor
Posts: 3,174

Re: Data Format!

Use the SCAN function in a DATA step to pick-off the third parsed sub-field, while having the "/" listed as the delimiter.

Scott Barry
SBBWorks, Inc.

SCAN Function
http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000214639.htm
Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation