topic Re: splitting a variable into several depending on parenthesis in SAS Data Management

splitting a variable into several depending on parenthesis

ilikesas — Tue, 05 May 2015 15:40:00 GMT

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!

Re: splitting a variable into several depending on parenthesis

LinusH — Tue, 05 May 2015 15:53:32 GMT

Use scan with ( as delimiter.

Compress ) from the results.

Re: splitting a variable into several depending on parenthesis

Steelers_In_DC — Tue, 05 May 2015 15:59:30 GMT

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;

Re: splitting a variable into several depending on parenthesis

Ksharp — Wed, 06 May 2015 13:46:43 GMT



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