topic Re: Split a long text string, 200 or less using a ';' delimiter- retaining the delimiter ';' in SAS Programming

Split a long text string, 200 or less using a ';' delimiter- retaining the delimiter ';'

jenim514 — Fri, 08 Mar 2024 20:26:47 GMT

Hello,

Need output to retain the semicolon delimiter when the string is split up. any ideas?

Here is my code (col1-col3 renamed CMDECOD,1,2) after the transpose.

data tmp (drop= i word); set db.cm (keep=subject cmtrt_product recordid);

length nystr $200;

cmtrt_product = compbl(cmtrt_product);

do i = 1 to countw(cmtrt_product,';');

word = scan(cmtrt_product,i,';');

if length(nystr) + length(word) + 1 > 200 then do;

output;

nystr = word;

end;

else nystr = catx(';',nystr,scan(cmtrt_product,i,';'));

end;

if nystr ne '' then output;

run;

proc sort data=tmp; by subject recordid;

proc transpose data=tmp out=want (drop=_name_);

by subject recordid ;

var nystr;

run;

ballardw — Fri, 08 Mar 2024 20:53:59 GMT

If you need a semicolon the add one before writing.

Instead of

if nystr ne '' then output;
run;

try

if nystr ne '' then do;
    nystr = cats(nystr,';');
    output;
end;
run;

himself — Fri, 08 Mar 2024 21:10:00 GMT

Hi, I came across such a question answerd in sas community:

Kindly have a look and see if you can incorporate the same in you code: