proc report for all the columns in a dataset

[bhu]

Assuming dataset table1 has field1, how can I use proc contents inside proc report? Or is there any way to display all the columns of the dataset without actually specifying the field names?

PROC REPORT data=table1 nowd split='\' nocenter;
COLUMN
(
proc contents data = table1 varnum short;
 run;

)
by fieldname1;
TITLE1 "Comparison";
RUN;

[bhu]

This helped me:

proc sql noprint;
select name into :var_list separated by " " from sashelp.vcolumn where libname="WORK" and memname="TABLE1";
quit;
PROC REPORT data=table1 nowd split='\' nocenter;
COLUMN
&var_list.;
by fieldname1;
TITLE1 "Comparison";
RUN;

[Reeza · Accepted solution]

You don't specify any, defaults are an awesome thing.

proc sort data=sashelp.class out=class;
by sex;

proc report data=class;
by sex;
run;

If you don't specify any, it defaults to all variables, similar to PROC REPORT. 

---

@bhu wrote:

Assuming dataset table1 has field1, how can I use proc contents inside proc report? Or is there any way to display all the columns of the dataset without actually specifying the field names?

PROC REPORT data=table1 nowd split='\' nocenter;
COLUMN
(
proc contents data = table1 varnum short;
 run;

)
by fieldname1;
TITLE1 "Comparison";
RUN;

---

[bhu]

Awesome Reeza. Thank you a lot for such an easy solution. I have changed the accepted solution to your reply.