topic Re: Scanning words with different length in SAS Programming

Scanning words with different length

T_me — Wed, 19 May 2021 12:48:50 GMT

Please help, I want to scan the words that are within the brackets.

Customer

Customer: Cho0012 (Industrial filling station T/A Caltex mogoboshane)

Customer: cho0013 (Choppies complex supermarket)

Customer: SPA0107 (K.A.W ENTERPRISES (PTY) LTD T/A SPAR MOGODITSHANE)

Thanks

T_me

Re: Scanning words with different length

PaigeMiller — Wed, 19 May 2021 12:53:38 GMT

What is the desired output?

Re: Scanning words with different length

asuman — Wed, 19 May 2021 14:42:29 GMT

For better understanding ,kindly provide the desired o/p also.But this might help you.

data test;
input customer & $200.;
cards;
Cho0012 (Industrial filling station T/A Caltex mogoboshane)
cho0013 (Choppies complex supermarket)
SPA0107 (K.A.W ENTERPRISES (PTY) LTD T/A SPAR MOGODITSHANE)
;
run;
data test1(drop=a b);
length a $200. c $200.;
set test;
a=compress(scan(customer,2, '('),')');
b=compress(scan(customer,3,'('),')');
c=catx('',a,b);
run;