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:
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;
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.
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;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.