Help using Base SAS procedures

hi

Reply
N/A
Posts: 1

hi

hi

input dataset:
a b
1 current:abcdedfgh previous:xyzwabc currentSmiley Tongueqr previous:klmnop
2 previous:dedfgh previous:wabc current:abcpqr current:abklmnop

i want output dataset as(i dont want previous conditon)
i need only current condition for example
1 current:abcdefgh currentSmiley Tongueqr
2 current:abcpqr current:abklmnop


Thanks

Super User
Posts: 10,044

Re: hi

Easy.

data have;
input a b & $100.;
cards;
1 current:abcdedfgh previous:xyzwabc current:pqr previous:klmnop
2 previous:dedfgh previous:wabc current:abcpqr current:abklmnop
;
run;
data want;
set have;
_b=prxchange('s/previous:\w+//i',-1,b);
run;

Ksharp

Super User
Posts: 10,044

Re: hi

OR. If you want more power.


data have;
input a b & $100.;
cards;
1 current:abcdedfgh previous:xyzwabc current:pqr previous:klmnop
2 previous:dedfgh previous:wabc current:abcpqr current:abklmnop
;
run;
data want;
set have;
_b=prxchange('s/previous:\S+//i',-1,b);
run;

Ksharp

Ask a Question
Discussion stats
  • 2 replies
  • 160 views
  • 0 likes
  • 2 in conversation