Using Scan Function to pull out text strings

jamesadams · Jun 3, 2010

Hi There. New to the forum so please forgive the basic question.

I have a variable and want to use the scan (I think) to pull out the account code. For example;

"Company ABC {1-7VF-244}"

I want to pull out the "1-7VF-244".

The company names are all of different length. All of the account numbers are the same lenght and format and all contained in those {} brackets.

Thanks.

klaz2002 · Jun 4, 2010

If you're sure that the data always appears the way you have described then you could use the scan function like so...

Code:

accountno = scan(Code,2,'{}');

This presumes that the string you mentioned resides in the variable named CODE. Of course you can also use the perl regex in SAS 9.x and up.

Good luck
Klaz

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Using Scan Function to pull out text strings

jamesadams

Programmer

klaz2002

Programmer

Similar threads

Part and Inventory Search

Sponsor