topic Re: Prxparse in SAS Programming

Prxparse

Kiteulf — Thu, 01 Mar 2018 11:30:46 GMT

I have this type of data:

125628,59000,.,.,.,.

.,50000,.,.,.,.

using

prx=prxparse("s/.,[., ]*/, /");

I get

12562, 5900, , , , .

, 5000, , , , .

I would like to have

125628,59000

50000

Re: Prxparse

RW9 — Thu, 01 Mar 2018 11:59:57 GMT

Well, perl I can't help you with, however its a simple thing in Base SAS code to do:

data have;
  tmp="125628,59000,.,.,.,."; output;
  tmp=".,50000,.,.,.,."; output;
run;

data want (drop=i);
  length tmp2 $200;
  set have;
  do i=1 to countw(tmp,",");
    if scan(tmp,i,",") ne "." then tmp2=catx(',',tmp2,scan(tmp,i,","));
  end;
run;

Re: Prxparse

andreas_lds — Thu, 01 Mar 2018 12:12:26 GMT

not fully tested:

data want;
   set have;
   tmp2 = transtrn(tmp, ',.', ' ');
   tmp2 = strip(transtrn(tmp2, '.,', ' '));
run;

Re: Prxparse

ChrisNZ — Thu, 01 Mar 2018 22:45:15 GMT

With a RegEx:

data t; 
  STR=prxchange('s/,\./ /', -1, '125628,59000,.,.,.,.');
  putlog STR=;
run;

STR=125628,59000