topic Re: i want to create a macro variable in SAS Programming

i want to create a macro variable

bismilla — Fri, 08 Mar 2019 05:02:43 GMT

i want a create a macro variable by taking all the values of the variable into the macro variable

ex;-

data ds1;

set sashelp.class;

run;

Re: i want to create a macro variable

Kurt_Bremser — Fri, 08 Mar 2019 05:24:50 GMT

Data belongs in datasets, not in macro variables.

To create macro variables in data steps, use the call symput() subroutine.

Re: i want to create a macro variable

andreas_lds — Fri, 08 Mar 2019 06:10:01 GMT

@bismilla wrote:

i want a create a macro variable by taking all the values of the variable into the macro variable

ex;-

data ds1;

set sashelp.class;

run;

Do want all values of one variable stored in a macro variable or do you want all values of all variables in one macro-variable?

As said by @Kurt_Bremser, storing data in macro variables is almost always not necessary and you will be forced to write more code, than necessary.

This is, by the way, one of the very, very rare cases, in which using proc sql is justified:

proc sql noprint;
  select Name 
    into :NameList separated by ' '
    from sashelp.class
  ;
quit;