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

[jenim514]

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 · Accepted solution]

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]

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:

link one split variables 

Link two split variables 2