topic Filtering URL addresses in SAS Procedures

Filtering URL addresses

pp2014 — Mon, 04 Apr 2016 14:31:58 GMT

I have a field in the dataset called webpage:

It has values as follows:

www.abc.com/about
www.abc.com/about-afib
www.abc.com/about/activations
www.abc.com/home/
www.abc.com/mobile
www.mobileabc.com/xyz.php

I want the following output:

www.abc.com/about
www.abc.com/home/
www.abc.com/mobile

Re: Help with data

RW9 — Mon, 04 Apr 2016 13:27:12 GMT

Not sure what the "question" is here or what the logic is. There a many ways to do that: if _n_ in (1,4,5) then output;, or if scan(<text),2,"/") in ("about","home","mobile") then output; etc.

Re: Filtering URL addresses

Ksharp — Tue, 05 Apr 2016 04:38:31 GMT



data x;
input x $80.;
y=scan(x,1,'/')||'/'||scan(x,2,'.','kad');
if findc(scan(x,-1,'/'),'.') then call missing(y);
cards;
www.abc.com/about
www.abc.com/about-afib
www.abc.com/about/activations
www.abc.com/home/
www.abc.com/mobile
www.mobileabc.com/xyz.php
;
run;