SAS: use dynamic macro variable in loop in macro program

Question

I want to achieve the same as:

data train_Sex(keep=Name Sex) train_Age(keep=Name Age) train_Height(keep=Name Height) train_Weight(keep=Name Height);
    set sashelp.class;
run;

using a macro program with a list of variables. As far as I went:

* Build macro program;
%macro build_sets(var_list);
    %let nwords = %sysfunc(countw(&var_list));

    %do i=1 %to &nwords;
        call symput("variable",  %scan(&var_list, i));

        data train_&variable(keep=Name &variable);
            set sashelp.class;
        run;

    %end;
%mend;

* Run it;
%let var_list = Sex Age Height Weight;
%build_sets(&var_list);

But I am lacking the knowledge how can I dynamically change the "variable" var.

Thanks!

similar questions:

1.SAS dynamically declaring macro variable 2. Using a dynamic macro variable in a call symput statement 3. Dynamic macro variable access SAS

Your macro isn't quite attempting to recreate the data set, instead it's pulling each variable out into an individual data set. If you're trying to create a fact/dim table there's a macro on SAS communities that does this automatically. — Reeza
– Reeza, Commented Nov 5, 2018 at 2:34

Kiran · Accepted Answer · 2018-11-04 22:45:30Z

1

you were close. below thing should work for you. call symput is part of datastep is used to create macrovariable from dvariables and hence the issue.

 %macro build_sets(var_list);
;

%do i=1 %to  %sysfunc(countw(&var_list));
    %let variable=  %scan(&var_list, &i));

    data train_&variable(keep=Name &variable);
        set sashelp.class;
    run;

%end;
%mend;

 * Run it;
%let var_list = Sex Age Height Weight;
%build_sets(&var_list);

edited Nov 4, 2018 at 22:45

answered Nov 4, 2018 at 22:35

Kiran

3,3153 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SAS: use dynamic macro variable in loop in macro program

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related