topic Re: Do Loop Increment with Delimiter in SAS Programming

Do Loop Increment with Delimiter

iSAS — Fri, 17 Jul 2020 09:00:25 GMT

Below is the dataset that I have:

I want to transform it like the data below:

I tried the code below but it isn't working:

data want;
set ref_table;
i=1;
do until (missing(pre_req));
pre_req=scan(pre_req,i,",");
i+1;
end;
run;

May I know how to modify this?

Re: Do Loop Increment with Delimiter

andreas_lds — Fri, 17 Jul 2020 09:12:40 GMT

You are overwriting pre_req in the loop, that can't work as expected. You need to extract the values to a new variable. Code is untested.

data want;
  set ref_table;

  do i = 1 to countw(pre_req, ',');
    new_pre_req = scan(pre_req, i, ",");
    output;
  end;

  drop pre_req;
  rename new_pre_req = pre_req;
run;

Re: Do Loop Increment with Delimiter

Shmuel — Fri, 17 Jul 2020 09:19:02 GMT

use next code:

data want;
  set ref_table(rename=(pre_reg=reqs));
  do i=1 to countw(reqs);
     pre_req = scan(reqs,i,",");
     outputl
  end;
run;