topic Re: How to separate a space delimited field into separate lines in SAS Programming

How to separate a space delimited field into separate lines

WestChan — Tue, 06 Jun 2017 00:25:12 GMT

Hello,

I have a field which appears in this format: XXXX YYYY ZZZZ

Where it is separated by space. I would like to make a new line per space delimited string. So for the above example there would be 3 lines create.

Any help would be appreciate?

Thanks.

kiranv_ — Tue, 06 Jun 2017 00:30:25 GMT

can you please show how output should look like

WestChan — Tue, 06 Jun 2017 00:36:55 GMT

Hello,

This is a basic structure which I am looking for:

Before:

After:

Thanks

Reeza — Tue, 06 Jun 2017 00:38:34 GMT

COUNTW to count the number of words

SCAN to extract the number of components.

n_words = countw(string);

do i=1 to n_words;
word = scan(string, i);
OUTPUT;
end;

A fully worked example is here:

Jagadishkatam — Tue, 06 Jun 2017 00:44:51 GMT

Please try

data want;
set have;
count=countw(variable,' ');
do i = 1 to count;
new=scan(variable,i,' ');
output;
end;
run;