topic Re: insert all variables of a dataset into one macro variable in SAS Programming

insert all variables of a dataset into one macro variable

mano — Mon, 15 Apr 2013 21:21:22 GMT

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 — Mon, 15 Apr 2013 22:12:47 GMT

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

Peter_C — Mon, 15 Apr 2013 22:13:29 GMT

do you want variables or variable values?

Tom — Mon, 15 Apr 2013 22:50:58 GMT

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 — Mon, 15 Apr 2013 23:30:44 GMT

Thank you Tom.

Ron_MacroMaven — Tue, 16 Apr 2013 10:59:04 GMT

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;