Splitting string data in multiple rows.

[Stretlow]

Hi.

I'm struggling a little with extracting string data from multiple rows via a delimiter. I have 1 variable named Rule_Results with multiple observations.

The data is pretty standard through out the rows, here's a snapshot of three rows:-

USERKNOWN=Y;SIGMATCH=N;SIGMATCHDEVICEALIAS=N;DEVICEIDCHECK=N;EXCEPTION=N;UNTRUSTEDIP=N; USERKNOWN=Y;SIGMATCH=N;SIGMATCHDEVICEALIAS=N;DEVICEIDCHECK=N;EXCEPTION=N;UNTRUSTEDIP=N; USERKNOWN=Y;SIGMATCH=N;SIGMATCHDEVICEALIAS=N;DEVICEIDCHECK=N;EXCEPTION=N;UNTRUSTEDIP=N;

What im trying to do is us the ";" delimiter to extract the data in between into a new row.

I've found the following on these boards but am struggling to get it to work. 

data loop;
set Import;

do i = 1 to countw(Rule_Results,';');
_Rule_Results_ = scan(Rule_Results,i,';');
end;

run;

Any help is appreciated. Stret

[Reeza · Accepted solution]

You're missing the OUTPUT statement to create a new record.

data loop;
set Import;

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

_Rule_Results_ = scan(Rule_Results,i,';');

OUTPUT;
end;


run;

[Stretlow]

So close!!! Thanks for the help