insert all variables of a dataset into one macro variable

[mano]

Hi,

For ex:- there are 16 variables in x dataset. If we use proc contents , we can see all the variables in the output window.

But, if I want to insert all these variables into one single macro variable, is there any way.

If i call that macro variable, we need to get all the 16 variables.

Any help is appreciated.

Thanks in advance,

Mano.

[Peter_C]

do you want any kind of delimiter, like for the heading of a CSV file?

[Peter_C]

do you want variables or variable values?

[Tom · Accepted solution]

If you want the variable names separated by spaces you get that from the output of PROC CONTENTS.

proc contents data=x noprint out=contents; run;

proc sql noprint ;

select name into :varlist separated by ' '

from contents ;

quit;

%put Variables are: &varlist ;

[mano]

Thank you Tom.

[Ron_MacroMaven]

skip the contents

%let Lib_Data = sashelp.class;

PROC SQL; select Name

            into :List_names separated by ' '

          from   dictionary.columns

          where  Libname eq "%upcase(%scan(&Lib_Data,1,.))"

            and  Memname eq "%upcase(%scan(&Lib_Data,2,.))"

            ;

          quit;

%put note: list_names = &List_names;