Split column into rows grouped by 2 other columns

ammarhm — Wed, 28 Jun 2017 12:32:53 GMT

I have a table that looks like the following

I would like to split the column "Code" by the deliminator ',' to the follwing

In other words, the string i the column (Code) will need to be split by the deliminator and grouped by the coulmns (User) and (Date)

Any suggession is appreciated

Kind regards

Re: Split column into rows grouped by 2 other columns

ammarhm — Wed, 28 Jun 2017 12:51:03 GMT

Sorry, found the solulsion :

data NewSet;

set OldSet;

Old= Code;

do i= 1 to (countw(Old));

New = scan(Old, i,',');

output;

end;

drop i Old Code;

run;