Passing a variable with mutliple values to a sas dataset column

[carles]

Good Morning!, 

I know this question might be silly but I am trying to achieve the following: 

(1) I have a variable for instance: %let Var1 = A B C;

Then I want to pass it in a Dataset column such that

data want; 

WantedColumn = &Var1;

run; 

However, this does not work. I have tried several combinations with PUT and SCAN but havent found the good one. 

 How is it done ??

Thank you for your time !,

[PeterClemmensen]

Put quotes around your macro variable

%let Var1 = A B C;

data want; 
    WantedColumn = "&Var1";
run; 

[carles]

This outputs me everything in one place but i want :

WantedColumn

A

B

C

NOT

Wanted Column

A B C

[PeterClemmensen · Accepted solution]

Then do

%let Var1 = A B C;

data want(drop=i); 
    do i=1 to countw("&Var1");
        WantedColumn=scan("&Var1", i);
        output;
    end;
run;