How to separate a space delimited field into separate lines

[WestChan]

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_]

can you please show how output should look like

[WestChan]

Hello, 

This is a basic structure which I am looking for: 

Before: 

id	Variable
1	XXXX YYYY ZZZZ
2	AAAA BBBB

After: 

id	new_variable
1	XXXX
1	YYYY
1	ZZZZ
2	AAAA
2	BBBB

Thanks

[Jagadishkatam · Accepted solution]

Please try

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

[Reeza]

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:

https://gist.github.com/statgeek/bed5ea2c12903b38fdcf19f3f1f1aae9