Extract within a string

LK357 — Tue, 28 Jun 2016 11:35:02 GMT

I am tring to extract the number following the id= from within this string below

http://www.blahblah/blahblah/confirmation?id=1234567&media=12345

Re: Extract within a string

ballardw — Fri, 01 Jul 2016 16:42:40 GMT

There are several ways depending on consistency of your input stream.

Here are two.

data want;
   string='http://www.blahblah/blahblah/confirmation?id=1234567&media=12345';
   /* if the ID ALWAYS appears in the same place*/
   oneway= scan(string,2,'=&');
   /* or if ID may appear in other locations*/
   /*find position of id=*/
   pos1 = index(string,'id=');
   /* find position of & AFTER the first position*/
   pos2= find(string,'&',pos1);
   otherway = substr(string,pos1+3,pos2-(pos1+3));
   /* not if your target string value exceeds 8 characters you should declare a length
   prior to use*/

run;

If the value needs to be actually numeric then you could use an INPUT such as

oneway = input(scan(string,2,'=&'),best16.);

But if there were any values not numeric such as id=123ABC456 that would fail.

Re: Extract within a string

LK357 — Thu, 07 Jul 2016 09:16:29 GMT

Excellent thanks for the reply!

topic Re: Extract within a string in SAS Programming

Extract within a string

Re: Extract within a string

Re: Extract within a string