topic delete within bracket () in SAS Procedures

delete within bracket ()

podarum — Tue, 22 Nov 2011 20:14:38 GMT

Hi, I'm trying to delete data that's within a bracket but keep the rest.

Have:

NAME
Sammy (NL)
Don (DP)
Greg (OL)
Fred Donalson (DE)
St. George B (BW)
Want:
NAME
Sammy
Don
Greg
Fred Donaldson
St. George B
I tried this :

do i=1 to count (NAME,'(');

NAME2 = scan(NAME,i);

output;

end;

delete within bracket ()

art297 — Tue, 22 Nov 2011 21:07:27 GMT

There are a number of ways. If you only have the one set of parentheses in each string, probably the easiest would be a slight modification of what you tried:

data have;

informat name $30.;

input name &;

cards;

Sammy (NL)

Don (DP)

Greg (OL)

Fred Donalson (DE)

St. George B (BW)

;

data want;

set have;

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

run;

delete within bracket ()

Linlin — Tue, 22 Nov 2011 21:15:36 GMT

another way:

data have;

informat name $30.;

input name &;

cards;

Sammy (NL)

Don (DP)

Greg (OL)

Fred Donalson (DE)

St. George B (BW)

;

data want;

set have;

name=substr(name,1,find(name,'(')-1);

run;

proc print;

run;

delete within bracket ()

Ksharp — Wed, 23 Nov 2011 02:37:11 GMT

data have;
  informat name $30.;
  input name &;
  cards;
Sammy (NL)
Don (DP)
Greg (OL)
Fred Donalson (DE)
St. George B (BW)
;
run;
data want;
 set have;
 a=prxchange('s/\(\w+\)/ /',-1,name);
run;

Ksharp