topic Re: subtring on a variable length field in SAS Programming

subtring on a variable length field

myboys2 — Wed, 16 May 2018 13:50:13 GMT

I am looking to grab the first few positions of a field before the '*" but as you can see the * is not in the same position of every record. I just want what is BEFORE the *

Below are sample records - not sure if a substring would work and if so how?

example

card id

12345*companyname

1234*companyname

99999999*companyname

22*companyname

Re: subtring on a variable length field

Kurt_Bremser — Wed, 16 May 2018 13:51:43 GMT

newfield = scan(oldfield,1,"*");

Re: subtring on a variable length field

myboys2 — Wed, 16 May 2018 13:58:59 GMT

thank you!