topic spliting variable into multiple variables without delimiter and words can cut in SAS Programming

spliting variable into multiple variables without delimiter and words can cut

deep_sas — Fri, 29 Jan 2021 11:52:21 GMT

Hi Everyone,

I have below data and I want to split the variable "VAR" into multiple variables after length of 9 .So after every 9th position in the string the sentence should split cutting words is fine. Please have a look at below datasets .Thank you in advance.

data have;

var="I want this text to split into variables with same length";

run;

Expected output:

var1 var2 var3 var4 var5 var6 var7
I want th is text to split into vari ables wit h same le ngth

Re: spliting variable into multiple variables without delimiter and words can cut

PeterClemmensen — Fri, 29 Jan 2021 12:14:42 GMT

Try this

data have;
   var="I want this text to split into variables with same length";
run;

data temp;
   set have;
   l = length(var);
   f = 1;
   do while (1);
      w = substr(var, f, 9);
      id + 1;
      output;
      f + 9;
      if f + 9 > l then do;
         w = substr(var, f);
         id + 1;
         output;
         leave;
      end;
   end;
run;

proc transpose data = temp out = want(drop = _:) prefix = var;
   id id;
   var w;
run;

Result:

var1       var2       var3       var4       var5       var6      var7 
I want th  is text t  o split i  nto varia  bles with  same len  gth