Converting list to dataset column

[Jedrek369]

I have a list of values separated by space.

%let list = A B C;

I would like to create a single-column dataset.

Col1

A

B

C

Thanks in advance!

[Kurt_Bremser · Accepted solution]

data want;
do i = 1 to countw("&list.");
  col1 = scan("&list.",i);
  output;
end;
drop i;
run;

[ballardw]

You may want to consider specifying a length for Col1 variable based on your knowledge of the starting list. The default length using @Kurt_Bremser's solution will create a variable that is the length of the entire list. If you have many values that could mean that you have a variable of several hundred (or thousand) characters even though the longest value of interest is only one or two or some other number much smaller than thousands.

[FreelanceReinh]

You can also let SAS determine the minimum required length of Col1:

data wide / view=wide;
retain c1-c%sysfunc(countw(&list,%str( )))
       ("%sysfunc(tranwrd(&list,%str( ),%str(" ")))");
run;

proc transpose data=wide out=want(drop=_:);
var c:;
run;