@andreas_lds wrote: Please edit the title and add something meaningful. The word "sas" does not tell anybody anything about the issue you need to be solved.   You should although add data in usable format (data step with datalines) and explain. based on the input you show, what do expect as result. He also has the right to say "Hello" don't you think ? haha ... View more

@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; ... View more