hi

[dpsas]

hi

input dataset:
a b
1 current:abcdedfgh previous:xyzwabc current:pqr 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 current:pqr
2 current:abcpqr current:abklmnop

Thanks

[Ksharp]

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

[Ksharp]

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