topic Re: hi in SAS Procedures

hi

dpsas — Thu, 03 May 2012 05:01:59 GMT

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

Re: hi

Ksharp — Thu, 03 May 2012 05:53:41 GMT

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

Re: hi

Ksharp — Thu, 03 May 2012 07:48:32 GMT

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