splitting a variable into several depending on parenthesis

[ilikesas]

hi,

suppose I have the following:

name
srjg5483h (djfhtbv  fjfj ) (fhfh 183 f)
fjj8 (f)
fkk   999999

I would like is to create new columns for the text within the parentheses (whenever present) :

name	info	code
srjg5483h (djfhtbv  fjfj ) (fhfh 183 f)	djfhtbv  fjfj	fhfh 183 f
fjj8 (f)	f
fkk   999999

thank you!

[LinusH]

Use scan with ( as delimiter.

Compress ) from the results.

[Steelers_In_DC · Accepted solution]

This will give you your desired output:

data have;

infile cards dsd;

length name $50.;

input name $;

cards;

srjg5483h (djfhtbv  fjfj ) (fhfh 183 f)

fjj8 (f)

fkk   999999

;

run;

data want;

set have;

info = scan(name,2,'(,)');

code = scan(name,4,'(,)');

run;

[Ksharp]

data have;
infile cards dsd;
length name $50.;
input name $;
cards;
srjg5483h (djfhtbv  fjfj ) (fhfh 183 f)
fjj8 (f)
fkk   999999
;
run;

proc sql;
select max(countc(name,'()'))/2 into : n separated by ' ' from have;
quit;
data want;
 set have;
 array x{*} $ 100 v1-v&n;
 do i=1 to &n ;
  x{i}=scan(name,i*2,'()','m');
 end;
 drop i;
 run;

Xia Keshan