BookmarkSubscribeRSS Feed
podarum
Quartz | Level 8

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;

3 REPLIES 3
art297
Opal | Level 21

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;

Linlin
Lapis Lazuli | Level 10

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;

Ksharp
Super User
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 718 views
  • 0 likes
  • 4 in conversation