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
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;
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;
not fully tested:
data want;
set have;
tmp2 = transtrn(tmp, ',.', ' ');
tmp2 = strip(transtrn(tmp2, '.,', ' '));
run;
With a RegEx:
data t;
STR=prxchange('s/,\./ /', -1, '125628,59000,.,.,.,.');
putlog STR=;
run;
STR=125628,59000
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: