Splitting string data in multiple rows.

Stretlow — Thu, 19 Apr 2018 15:00:37 GMT

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

Re: Splitting string data in multiple rows.

Reeza — Thu, 19 Apr 2018 15:02:55 GMT

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;

Re: Splitting string data in multiple rows.

Stretlow — Thu, 19 Apr 2018 15:10:55 GMT

So close!!! Thanks for the help

topic Re: Splitting string data in multiple rows. in SAS Procedures

Splitting string data in multiple rows.

Re: Splitting string data in multiple rows.

Re: Splitting string data in multiple rows.