*Method1: Using Proc Contents and Proc SQL;
proc contents data=sashelp.class out=class;
run;
proc sql noprint;
select distinct(name) into:vars separated by " " from class;
quit;
%put &vars;
*Method2: Using SASHELP tables and Proc SQL;
data class;
set sashelp.vcolumn(where=(libname="SASHELP" and memname="CLASS"));
keep name;
run;
proc sql noprint;
select distinct(name) into:vars separated by " " from class;
quit;
%put &vars;
1 comments:
%let dsid=%sysfunc(open(&lib..&dsn,i));
%let numvar=%sysfunc(attrn(&dsid,nvar));
%do j =1 %to &numvar;
%let colname=',';
%let colname1=%sysfunc (varname(&dsid,&j));
%let colname=&colname1||&colname;
%end;
%let rc=%sysfunc (close(&dsid));
Post a Comment