topic Re: Passing a variable with mutliple values to a sas dataset column in SAS Programming

Passing a variable with mutliple values to a sas dataset column

carles — Thu, 03 Oct 2019 07:40:49 GMT

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 — Thu, 03 Oct 2019 07:42:28 GMT

Put quotes around your macro variable

%let Var1 = A B C;

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

carles — Thu, 03 Oct 2019 08:13:03 GMT

This outputs me everything in one place but i want :

WantedColumn

NOT

Wanted Column

A B C

PeterClemmensen — Thu, 03 Oct 2019 08:16:32 GMT

Then do

%let Var1 = A B C;

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